Homework Help Question & Answers

This question is from the subject: Database Systems QUESTION 4 Consider the ER Diagram. Which of...

QUESTION 4 Consider the ER Diagram. Which of the following are valid schemas that result from transforming this diagram into

This question is from the subject: Database Systems

QUESTION 4 Consider the ER Diagram. Which of the following are valid schemas that result from transforming this diagram into a simplified schema (i.e., after relationships are merged)? Select all that apply. course name phone address name Chefs signature Dishes Member 1 main Team Ingredients name points name 1. Team(name, points) 2. Signature(chef, dish) FK chef REF Chefs(name) FK dish REF Dishes(name) 3. Chefs(name,phone,address,team) FK team REF Team(name) 4. Ingredients(name, dish) FK dish REF Dishes(name)
0 0
Next > < Previous
ReportAnswer #1

Team(name,points) is valid as it has two attributes and is atomic.

second is also valid by simplifying from above schema we can make foreign key to chef name and the dish he will prepare.

fourth one is not valid as the functional dependency will change for the following schema.

Know the answer?
Add Answer of:
This question is from the subject: Database Systems QUESTION 4 Consider the ER Diagram. Which of...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
Share Your Knowledge

Post an Article
Post an Answer
Post a Question with Answer

Self-promotion: Authors have the chance of a link back to their own personal blogs or social media profile pages.