Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

data in the table are attached below

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design And Implementation

Authors: Shouhong Wang, Hai Wang

1st Edition

1612330150, 978-1612330150

More Books

Students also viewed these Databases questions

Question

37 Lu Caningstatind for and centin pe inal the the times t F

Answered: 1 week ago