Question: You will need to analyze the data in the spreadsheet and determine functional dependencies. Show your work at each step of 1NF,2NF,3NF. Once the relations

You will need to analyze the data in the spreadsheet and determine functional dependencies. Show your work at each step of 1NF,2NF,3NF. Once the relations are in 3NF create a detailed ERD. After you have your detailed ERD.

Report 1.

List of Classes by semester and in which building they are taught.

Report 2

List of Classes and which Instructor teaches it.

Report 3

List of Students and their grades.

Id CourseNum CourseName InstructorId InstructorPrefix InstructorName SemesterNum SemesterYear SemesterSeason StudentId FirstName LastName Email Gender Birthdate BuildingNum BuildingName Grade
1 BIOL-211A Microbiology 4 Mr Williamson 2014FA 2014 Fall 289-12-6024 Louis Clark lclarko@bbb.org Male 6/29/1996 2 Library 4
2 ACCT-494Z Topics: Acct Res & Analysis I 14 Dr Jones 2014SU 2014 Summer 105-63-6433 Amanda Bowman abowmani@hubpages.com Female 11/23/1985 4 St. Albert 3
3 CHEM-341A Medicinal Chemistry 19 Mr Fisher 2015SU 2015 Summer 470-98-9023 James Davis jdavis11@cbslocal.com Male 9/10/1980 4 St. Albert 2
4 HIST-112A Hist of World Civ 1500 to Pres 3 Dr Oliver 2014FA 2014 Fall 973-08-5293 Dorothy Fox dfox19@phoca.cz Female 5/15/1995 2 Library 4
5 ENGL-200A Introduction to Literature 4 Mr Williamson 2014SP 2014 Spring 494-32-1646 Edward Hill ehilla@unc.edu Male 10/14/1980 2 Library 2
6 HIST-111A Hist of World Civ to 1500 8 Mr James 2015SU 2015 Summer 328-70-7072 Jessica Jordan jjordanw@clickbank.net Female 12/4/1994 1 Tower 3
7 CHEM-120A Foundations of Chemistry 1 Dr Harvey 2015SU 2015 Summer 105-63-6433 Amanda Bowman abowmani@hubpages.com Female 11/23/1985 2 Library 3
8 ACCT-126A Managerial Accounting 17 Mrs Anderson 2014FA 2014 Fall 470-98-9023 James Davis jdavis11@cbslocal.com Male 9/10/1980 3 Rec Center 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

CustomerID CustomerName OrderID ProductID ProductName OrderQty UnitPrice DiscoutTier OrderDate Addr City State Zip Del.Company ord001 Pro001 ord002 Pro002 Cust001 Paul Jones ord003 Pro003 Peppermint...

Q:

Part A: Draw the ER diagram Identify the business situation ( a small / medium size business ) , that you wish to design a database for. The situation needs to be a real life one ( not an imaginary...

Q:

Part A: Draw the ER diagram Identify the business situation ( a small / medium size business ) , that you wish to design a database for. The situation needs to be a real life one ( not an imaginary...

Q:

Please provide 1 nf , 2 nf , and 3 nf for this table. Lable each dependency on the diagram, as well as equations. 1 . Using the filled in report, draw it's 1 NF dependency diagram [ see figure 6 . 3...

Q:

Create a set of 3 NF normalized relations ( or tables ) given the sample data / form below. Do not draw a dependency diagram; only the relational schema is needed. Start with a single table ( could...

Q:

I need help for Step 3 please? 1NF, 2NF, 3NF for this data! Thank you! Use Case Description: ABC Supply Company needs to keep track of their office and computer inventory in order to reduce costs,...

Q:

Please help. This is for CIS336 Lab 1: Normal Forms and Entity Relationship Diagrams. In the exercise, you will analyze a de-normalized data set presented in the form of a spreadsheet. You will next...

Q:

This is my college Database coursework. I have a problem regarding making the erd diagrams and normalization(UNF, 1NF, 2NF, 3NF). I hope you would help me in making this along with the final erd...

Q:

For the problem below create a set of 3 NF normalized relations ( or tables ) given the sample data / form below. Do not draw a dependency diagram; only the relational schema is needed. Start with a...

Q:

based on accuracy ) Create a set of 3 NF normalized relations ( or tables ) given the sample data / form below. Do not draw a dependency diagram; only the relational schema is needed. - Start with a...

Q:

A small company produces three kinds of guitars, traditional, electric and bass, in two factories. Factory A produces 8 traditional, 5 electric and 10 bass guitars in one day, while factory B...

Q:

Draw the simplified curved arrow mechanism for the mechanistic step of (E) -3,5-dimethylhept-3-em-2-one and (CH 3 CH 2 ) 2 CuLi to give the major charged species which is formed. Draw all electrons...

Q:

When audit clients use a database system, the relating data is organized in a consistent manner which tends to make it easier for auditors to select items for testing. Group of answer choices True...

Q:

Give answers to the following questions with refrences 1 . What is the power and value of Toyota company for being recognized as a top employer in this specific competition of Canada s Top 1 0 0...

Q:

5.98 Financial Managers, Inc., buys and sells a large number of stocks routinely for the various accounts that it manages. Portfolio manager Sarah Bloom has asked for your assistance in the analysis...

Q:

5.97 Financial Managers, Inc., buys and sells a large number of stocks routinely for the various accounts that it manages. Portfolio manager Andrea Colson has asked for your assistance in the...

Q:

5.93 In a large department store a customer-complaints office handles an average of six complaints per hour about the quality of service. The distribution is Poisson. a. What is the probability that...