I have the attached two questions and have no idea how to answer.

 

 

MIS542’Database’Management,’Assignment’5’Total Points: 10 pointsOn Time Submission: late for 1 day -1 point, late for more than 1 day -2 points, Latefor more than a week -3 points.Each question is worth 2 point.Use the inappropriate schema style (-2 points).This assignment is a conceptual assignment on Normalization. There are twoproblems in this assignment. You need to follow the steps of normalizationdescribed in Chapter 3 of your textbook to normalize the relations in the givenproblems. Write your answers to one single Word Document (or Rich Text File).Your answers must be written in textual schema language. You can use the styleshown in the textbook or using SQL language.Do not capture the Table view. Yourtextbook use the table view with data to show the process of normalization. It is noefficient to capture the sample/partial table to describe your relations. Submit yourwork before deadline through the assignment page.Please see the following example for proper written style for schema.ORDER(OrderNumber, Date, Total)ORDER_ITEM(OrderNumber,ItemNumber, ItemName, Quantity)Problem’1:’ ’Consider the following relationCOURSE(CourseNumber, CourseName, CourseSection, TeacherName, ScheduledDay,ScheduledHour, ClassRoom, StudentNumber, StudentName, Grade)The attributes can be described asThere are certain functional dependencies are known.Each class has a unique teacherOnly one course can meet in a given scheduled hour in a particular roomA teacher can be in only one room at a given hourA student can be in only one room at a given hourA student only gets one grade in a courseAssume that TeacherName is unique. That is, no two teachers have the same name.Please answer the following questions.1.What are all the keys for Courses? (2 points)2.Normalize this relationship toa.BC/NF Normal Form and Third Normal Form (2 points)

• 1496040070-MIS542Assignment5.pdf

ComputerScienceExpert

(11)

Status NEW Posted 29 May 2017 06:05 AM My Price 8.00

-----------

Attachments

file 1496040072-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer