Consider This Table Of Sample Data Create A Database Schema Normalized To 3nf Identify Any Assumptions You Make About 1 (21.13 KiB) Viewed 38 times
Create a database schema normalized to 3NF.• Identify any assumptions you make about the requirements• Add or revise attributes if needed• List all FDs and candidate keys• Sketch ERD as “Intermediate” design showing all tables andattributes
Child Name Margo Robert Robert Julia Samuel Robert Child_Age 10 12 12 11 9 Teacher_Name Pet_Type Ms. Smith Mr. Jones Mr. Jones Ms. Smith Ms. Smith Ms. Smith dog cat dog cat goldfish canary Pet_Name Rex Fluffy Puffy Sphinx Puffy Tweety
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!