Chat with us, powered by LiveChat Set Theory as a Framework for Relational Databases A set can be a collection of any type of object, ranging from people to places to things. Basic set theory includes the study of sub - Wridemy Bestessaypapers

Set Theory as a Framework for Relational Databases A set can be a collection of any type of object, ranging from people to places to things. Basic set theory includes the study of sub

 I need initial post and 2 responses to my classmates, see attached for my classmates' initial responses.

Set Theory as a Framework for Relational Databases

A set can be a collection of any type of object, ranging from people to places to things. Basic set theory includes the study of subsets, proper subsets, finite and infinite sets, and the logical operations on them. Set theory plays a foundational role in mathematical processes and ideas and also has connections to computer engineering, programming, and databases.

The relational database model, originally invented by computer scientist Edgar F. Codd in 1969, is based on ideas from set theory. A simple database is a collection of records stored in tables. A relational database also includes relationships stored across multiple tables. One can run queries on the relational database to request specific information with set theory operators, such as union and intersection.

Post 1: Initial Response

Imagine you are responsible for your organization’s analytic tasks, and you are currently brainstorming how to query a relational database of marketing information for the organization. You want to test your understanding of how you might relate the database tables with the use of set theory, and particularly subsets. To carry out your test, complete each of the following:

  1. To define two sets, set A and set B, first conduct an online browsing trial, in which you spend 10–20 minutes looking at different websites, such as for national news, social media, sports, hobbies, recipes, etc. Let set A represent exactly three distinct company names from any online advertisements you saw during your browsing trial. Let set B represent at least three distinct company names for any online retailers you have purchased from in the past year.
  2. To prepare to use your algorithm, answer the following questions:
    • How many elements are in set A? This is what you will set as m = ___.
    • How many elements are in set B? This is what you will set as n = ___.
    • What are your first and last elements of A? Show these as a[1] = ____ and a[m] = ___.*
    • What are your first and last elements of B? Show these as b[1] = ____ and b[n] = ___.*

*Note: Recognize that there are other elements you will cycle through as you trace the algorithm. While you are not required to list all elements in this form, you will need to use them, in addition to the first and last elements, as you complete your trace.

  1. Using your sets A and B along with what you just outlined to prepare, determine an algorithm that you can use to see whether A ⊆ B.
  2. State the algorithm that you would use to compare these sets.
  3. Based on your algorithm, did you find that A ⊆ B or that A ⊈ B? Explain. If A ⊈ B, how are they related (e.g., disjoint, intersecting)?

View Unit 6 Discussion Post 1 example.

Post 2: Reply to a Classmate

Now you want to try out the algorithm on another person’s data to further test your understanding and bolster your confidence about assessing relations computationally as you approach this relational database project.

Review a classmate’s post and consider their set B. Address the following items completely.

  1. Using your set A and their set B determine whether A ⊆ B or that A ⊈ B? Explain how you know this. If A ⊈ B, how are they related (e.g., disjoint, intersecting)?
  2. How might the understanding you have gained from your Post 1 and Post 2 tests be useful if you were responsible for querying a relational database?

View Unit 6 Discussion Post 2 example.

Post 3: Reply to Another Classmate

After conducting this computational practice, you have begun to develop some technical insight into how you might investigate and seek information on the marketing habits of clients by querying a relational database. However, you know your fellow staff members are not interested in this technical insight. So, for your general meeting, you plan to present a visual synopsis of some ideas considered in the planning stages of this project.

Review another classmate’s post and consider their sets A and B. Address the following items completely.

  1. Create a Venn diagram that models all of the elements in your classmate’s sets A and B. Carefully place elements appropriately in the intersecting versus non-intersecting areas representing sets A and B, respectively. You may use the software of your choice for the Venn diagram (e.g., creatly.com, cosketch.com, Microsoft® Word®, or PowerPoint®). Copy and paste the image or screenshot of your Venn diagram into your post. (You may also use an attached file if needed.)
  2. Draft some talking points in anticipation of addressing the following questions during your presentation:
    • How do these two sets relate in the example illustrated by the Venn diagram?
    • How have the concepts of sets and set operations been utilized in your analytic tasks?
    • How might table relationships be modeled from the ideas of set theory?

Brandon Sembera posted Jan 22, 2023 10:47 PM

Subscribe

Having browsed online, I've seen ads for Amazon, Ford, and Newegg. Some online retailers that I've purchased from are Amazon, Walmart, and Lowe's. Therefore:

A = {Amazon, Ford, Newegg}

B = {Amazon, Walmart, Lowe's}

Cardinality of set A: n(A)=3, therefore m=3

Cardinality of set B: n(B)=3, therefore n=3

First & last elements of set A: a[1]=Amazon, & a[3]=Newegg

First & last elements of set B: b[1]=Amazon & b[3]=Lowe's

A trace table illustrates how both sets are related:

Set A

1

2

3

Set B

1

1

1

found

yes

no

no

answer

A⊆B

A⊄B

A⊄B

The table illustrates a portion of the trace, where one intersection exists: Amazon. Otherwise, if the trace continues, no other intersections can be found. Overall, set A cannot be a subset of set B due to sharing only one element with each other.

Jay Wilt posted Jan 21, 2023 8:17 PM

Subscribe

Hello Everyone,

1.

            Set A: Xfinity-NY Times, USAA-I Heart eating, The Nature Conservatory-PC Gamer

            Set B: Target, Amazon, Walmart, Food Lion

2.

            m= 3

            n= 4

            a[1]=Xfinity

            a[m]=The Nature Conservatory

            b[1]=Target

            b[n]=Food Lion

3.

I

 

 

 

 

1

2

3

J

1

2

3

4

 

 

 

Found

No

No

No

No

No

No

No

4.

            My algorithm shows that A ⊈ B. They are completely unrelated in every aspect somehow. This is a nightmare and I hope I have done this right.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?