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 | WriteDen

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.

HOW OUR WEBSITE WORKS

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.

Step 1

To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. 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.
 Deadline range from 6 hours to 30 days.

Step 2

Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

Step 3
Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

Is it Safe to use our services?
We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

Discounts

Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.