Describe how each table meets 1NF, 2NF and 3NF, if you need to remove any issues to move to the next higher NF describe what the issue is and how you resolved it.

Individual Project 3

Now that the ERD is completed for your selected project, you are anxious to create the database and setup the tables. Before that step you remind everyone that the 2nd phase in the Database development process has not been completed yet. You still need to create the Logical Data Model and check the model against 3rd Normal Form. For this Individual Project convert your ERD into a Logical Data Model that is in 3NF. The deliverables for this task are:

  • 1 Logical Data Model analyzed and converted to 3NF
  • Describe how each table meets 1NF, 2NF and 3NF, if you need to remove any issues to move to the next higher NF describe what the issue is and how you resolved it.
  • Properly Identify all Primary (Use Solid Underlines) and Foreign Keys (Use Dotted Underlines)

Add the normalized Logical Data Model and normalization discussion to the section in your template titled: The Logical Model and Normalization.

  • Update the TOC to reflect the new section.
  • Name the document CS251_<First and Last Name>_IP3.doc.
  • Submit the document for grading.

Deliverable Length:1 Word Document with Narrative describing Dependency Solutions; 1 Logical Data Model showing Primary

 

I am doing my database project of a library database management system, Attached is what  I have so far

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.