Database multiple-choice. 5 small part question using the scenario below! Social
ID: 3607407 • Letter: D
Question
Database multiple-choice. 5 small part question using the scenario below!
Social toys is a social website targeted at children. In order to join the website children need to create an account. They must enter their first name, last name and date of birth. They must also select at least one of their toys from the list of toys.
All toys are listed with their name, brand and collection (e.g.'Arendale Castle' by Lego © in the Frozen © collection). A toy may not belong to a collection or may belong to as many as 2 collections. Toys may be listed before they become available for children to own (e.g. ‘this toy is available in 30 days’)
Once a child has created their account and selected at least one toy they can become friends with other children. Children can choose to share pictures on the website and choose whether these are shared with only their friends, or publically (e.g. share to everyone on the website). When a child shares a picture on the website, they can tag their toys in the picture. They could share a picture several times and tag a different toy each time. When a picture is shared with a child, they can choose to comment or like it.
A partial ERD of the database is below.
Child Toy Owns> firstName lastName dateOfBirth brand A..B C..D name collection Picture ID fileAddress dateExplanation / Answer
Q1.
0..n Owns 0..n
A = 0, B= n, C =0, D =n
A child can have any number of Toys and A toy can belong to many children. So 'Owns' is many to many repationship
Q2.
n > 5 (many to many)
Q3. Primary key for Child entity
lastName, firstName, dateOfBirth
Q4.
n > 5
Q5.
brand, name : both combinely identify unique toy
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.