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 C 1800 Advance 3 martin lucker SQL 1800 Advance 4 alland bradley married C++ 1500 Basic 4 alland bradley Married Web Design 1800 Advance S pink Floid single Music 2000 Advance 5 Pink Floid single Computer Science 2000 Advance He knows you are taking SQL class and is asking you: To normalize these data up to 3NF. (35 points). And provide an ER diagram. (35 points). Requirements: Use lucid chart for the ER diagram. Teacher Name 1 Miss Lovelace 2 Pascal 3 Einsten 4 Sartein 3 Einsten 4 Villamil 4 Villamil 5 Peter Pan 6 Drums Sticks 1 Miss Lovelace A

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

Put Your Data To Work 52 Tips And Techniques For Effectively Managing Your Database

Authors: Wes Trochlil

1st Edition

0880343079, 978-0880343077

More Books

Students also viewed these Databases questions

Question

b. Will new members be welcomed?

Answered: 1 week ago