3. Given the following table, create a relational database in MS Access through normalization. Ensure that...

Transcribed Image Text:

3. Given the following table, create a relational database in MS Access through normalization. Ensure that each table is in at least 3NF. You may include additional attributes as necessary (30 points). DEPT NAME STU NUM STU LNAME STU MAJOR 211343 Stephanos 200128 Smith 199876 Jones 198648 Ortiz 223458 McKulski Accounting Accounting Marketing Marketing Statistics DEPT CODE ACCT Accounting ACCT Accounting MKTG Marketing MKTG Marketing MATH Mathematics DEPT COLLEGE ADVISOR ADVISOR ADVISOR ADVISORSTU GPA HOUR STU_CLASS PHONE NAME LNAME OFFICE BLDG PHONE 4356 4356 4378 4378 3420 Business Admin Business Admin Business Admin Business Admin Arts & Sciences Grastrand 201 Grastrand T201 Geetry Tibery Chen T228 T356 J331 Torre Building Torre Building Torre Building Torre Building Jones Building 2115 2115 2123 2150 3209 3.87 2.78 2.31 3.45 3.58 75 Junior 45 Sophomore 117 Senior 113 Senior 87 Junior 3. Given the following table, create a relational database in MS Access through normalization. Ensure that each table is in at least 3NF. You may include additional attributes as necessary (30 points). DEPT NAME STU NUM STU LNAME STU MAJOR 211343 Stephanos 200128 Smith 199876 Jones 198648 Ortiz 223458 McKulski Accounting Accounting Marketing Marketing Statistics DEPT CODE ACCT Accounting ACCT Accounting MKTG Marketing MKTG Marketing MATH Mathematics DEPT COLLEGE ADVISOR ADVISOR ADVISOR ADVISORSTU GPA HOUR STU_CLASS PHONE NAME LNAME OFFICE BLDG PHONE 4356 4356 4378 4378 3420 Business Admin Business Admin Business Admin Business Admin Arts & Sciences Grastrand 201 Grastrand T201 Geetry Tibery Chen T228 T356 J331 Torre Building Torre Building Torre Building Torre Building Jones Building 2115 2115 2123 2150 3209 3.87 2.78 2.31 3.45 3.58 75 Junior 45 Sophomore 117 Senior 113 Senior 87 Junior

Answer rating: 100% (QA)

The image shows a spreadsheet with data on students departments and advisors To create a relational database in MS Access through normalization ensuri... View the full answer