Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Teacher Id A professor has a flat database like the following: 10 First Name Last Name Marital Status Course Grade Fee (US dol Qualification 1

image text in transcribed
Teacher Id A professor has a flat database like the following: 10 First Name Last Name Marital Status Course Grade Fee (US dol Qualification 1 Kevin Drum single Computer Science 2000 Advance 1 Kevin Drum single Mathematics B 2500 Advance 1 Kevin Drum Single Physics 1800 Advance 2 Alexander Genious Married Economic A 2500 midle 2 Alexander Genious Married Physics 1800 Advance 3 martin lucker SOL A 1800 Advance 4 aliand bradley married C++ A 1500 Basic 4 alland bradley Married Web Design A 1800 Advance 5. Pink Floid single Music A 2000 Advance 5 Pink Floid Computer Science 2000 Advance He knows you are taking SQL class and is asking you: Teacher Name 1 Miss Lovelace 2 Pascal 3 Einsten 4 Sartein 3 Einsten 4 Villamil 4 Villamil 5 Peter Pan 6 Drurns Sticks 1 Miss Lovelace single To normalize these data up to 3NF. (35 points). And provide an ER diagram. (35 points). Requirements: Use lucid chart for the ER diagram

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

Principles Of Multimedia Database Systems

Authors: V.S. Subrahmanian

1st Edition

1558604669, 978-1558604667

More Books

Students also viewed these Databases questions