Question
1. What to do? a): Improve the data model below here by normalizing it up to BCNF You have to explain and arguments for the
1. What to do?
a): Improve the data model below here by normalizing it up to BCNF You have to explain and arguments for the choices you make for each of the normal shapes 1st, 2nd, 3rd, and BC Normal Form.
b): Make a logical data model of the normalized model using MySQL WorkBench Make the necessary assumptions if something is unclear or you think it needs adjustment.
2. What to submit
A word document (* .docx) containing
a): Explanation of your procedure for the choices you make during the normalization of the data model with associated figures and
b): figure of the finished normalized model from MySQL Workbench (screenshot) inserted into the document.
3. The data model lending
data in the table are attached below
Utln LID* EksNr UtDato Eksemplar EksNr Bok ISBN Titte Tittel CDNr* Forfatter Artist CD CDEksemplar BokEksemplar Lner LID Etternavn, fornavn Gatenavn, Postnummer, Poststed tlfnr ISBN* EksNr* nr EksNr* Levert AntSider Varighet Lner eksempel Tifnr Primr Nkkel Fremmed Nkkel LID Etternavn, fornavn Gatenavn, ostnummer, poststed Perveien 3, 3234 Perbyen Olsveien 2, 3223 Olsbyen Benveien 5, 3254 Benbyen Tonveien 2, 3225 Tonbyen PK 34 23346576 43541243 34547698 persen, per FK* 23 olsen, ole FK som PK* 54 bentsen, bente 32905487 25 32436578 98547683 32548965 43549832 tonesen, tone 76 Jenveien 7, 3276 Jenbyen jensen, jens Bok Utln LID EksNr* CD CDnr EksNr TittelCDNr* Eksemplar CDEksemplar BokEksemplar Lner LID Etternavn, fornavn Gatenavn, Postnummer, Poststed tlfnr EksNr ISBN ISBN* Tittel EksNr* UtDato Forfatter Artist Levert AntSider Varighet Lner eksempel Gatenavrn, postnummer, poststed Perveien 3 3234 Perbyen43541243 Olsveien 2, 3223 Olsbyen Benveien 5 3254 Benbyen Primr Etternavn, fornavn LID Tifnr PK Nkkel 23346576 Fremmed Nkkel 34 persen, per FK* 23 olsen, ole 34547698 FK som PK* bentsen, bente 54 32905487 32436578 98547683 32548965 Tonveien 2, 25 tonesen, to 2 Tonbyen Jenveien 7, jensen, jen53276 Jenbyen 43549832 76
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started