Question

ASSIGNMENT 03.1: Normalize a Schema Start Assignment Due Sunday by 11:59pm Points 100 Submitting a file upload File Types pdf Available until Jul 15 at 11:59pm Format: Individual Normalize the following relational schema into at least Third Normal Form (3NF) and show that all entities are in at least 3NF. Make a copy of the diagram Normalization-ERD E, in LucidChart and then modify that copy (use File/Duplicate in LucidChart -- do not ask for edit access as we cannot have you edit a shared document, for obvious reasons). The ERD is reproduced below for reference but you must open the link , and copy the diagram and then modify that copy. Module PK |mid integer name text contains A complTime time FK cid integer Lesson contains A PK lid text Course PK cid title text CK url text integer to aTime numeric difficulty numeric instructorName text instructorEmail text instructorFee numeric . You may collaborate and discuss this problem with up to two peers in private and you may post questions on the course forum but you may not seek the assistance of anyone outside the course. . You must make an individual submission, i.e., you and your discussion partner cannot submit the same diagram. . Add additional entities (tables) as required to the above model to accommodate requirements that are not correctly represented in the model that we provide. . Resolve any many-to-many relationships. Submission Submit a PDF that contains the revised ERD (in Crow's Foot Notation) and your "proofs" of 3NF compliance. You do not need to (but should) update the glossary or sample tables. By "proof" we mean that you need to show that each table is in 3NF by listing the functional dependencies and explain that the list of FDs meet the requirements of 3NF. . You may collaborate and discuss this problem with up to two peers in private and you may post questions on the course forum but you may not seek the assistance of anyone outside the course. · You must make an individual submission, i.e., you and your discussion partner cannot submit the same diagram. . Add additional entities (tables) as required to the above model to accommodate requirements that are not correctly represented in the model that we provide. · Resolve any many-to-many relationships. Submission Submit a PDF that contains the revised ERD (in Crow's Foot Notation) and your "proofs" of 3NF compliance. You do not need to (but should) update the glossary or sample tables. By "proof" we mean that you need to show that each table is in 3NF by listing the functional dependencies and explain that the list of FDs meet the requirements of 3NF. CS5200.A2.Rubric.SuF24 Criteria Ratings Pts ERD uses IE/Crow's Foot notation correctly. 10 pts Full Marks 0 pts No Marks 10 pts Work is clean and professional; easy to read. 5 pts Full Marks 0 pts No Marks 5 pts Schema is in 3NF 60 pts Full Marks 50 pts Mostly correct 0 pts No Marks 60 pts "Proof" on 3NF listing FDs 25 pts Full Marks 20 pts Mostly correct 10 pts Acceptable 0 pts No Marks 25 pts Total Points: 100

Get Instant Homework HelpOn Your Mobile

Get Instant Homework HelpOn Your Mobile

Get Instant Homework HelpOn Your Mobile