Hi, I need help with Deliverable #2 in the attached doc about SQL normalization.

 

Here is the exact question from the doc:

Normalize the relations to at least third normal form.

 

Identify the primary and foreign keys for each relation (using appropriate notation).

 

Identify and describe referential integrity constraints needed to guarantee the integrity of your database – Explain your choices.

 

Submit your normalized relations with the PKs, FKs, and constraints identified

 

MIS331 Semester Project – Spring 2016Your Assignment:Developing a database to ft the needs oF an organizaTon involves interpreTng requirements, designingthe database, and then implemenTng your design. ±o be²er prepare you For post-graduaTon work in MISrelated felds, you will work through these processes during the course oF this semester. Students arerequired to work independently. You will be given a business case and applicaTon requirements. Allstudent will be given the same scenario and requirements, but each individual is expected to come upwith his/her own interpretaTon oF the requirements, and his/her own unique soluTon.Your Grade:Your overall project grade will be a combinaTon oF the Following:DeliverableGradeDescripTonDue Date1.EnTty RelaTonshipDiagram25 points maxCreate and submit both a preliminaryand an implementaTon enTty-relaTonship diagram showing theconceptual data model For your system.March 72.Logical Database Design25 points maxNormalize the relaTons to at least thirdnormal Form.IdenTFy the primary and Foreign keys Foreach relaTon (using appropriatenotaTon).IdenTFy and describe reFerenTalintegrity constraints needed toguarantee the integrity oF your database– Explain your choices.Submit your normalized relaTons withthe PKs, ³Ks, and constraints idenTfed.March 283.DatabaseimplementaTon20 points maxDefne your database(1) Create the tables needed toimplement your database(2) Defne keys and indexes(3) Defne the relaTonships among yourtables.(4) Defne any necessary reFerenTalintegrity constraints between yourtables.(5) Add sample data to the databasetables (each table should have at leastApril 29

• 1495701053-MIS 331 Project Instructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 25 May 2017 08:05 AM My Price 8.00

-----------

Attachments

file 1495701055-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer