Question: StdSSN StdCity StdClass OfferNoOffTerm OffYear EnrGrade |CourseNo Crsdesc JUN JUN 3.5 3.3 3.1 3.4 3.2 S1 SEATTLE SEATTLE BOTHELL JUN BOTHELL JUN BALTIMORESEN O1 02

StdSSN StdCity StdClass OfferNoOffTerm OffYear EnrGrade |CourseNo Crsdesc JUN JUN 3.5

StdSSN StdCity StdClass OfferNoOffTerm OffYear EnrGrade |CourseNo Crsdesc JUN JUN 3.5 3.3 3.1 3.4 3.2 S1 SEATTLE SEATTLE BOTHELL JUN BOTHELL JUN BALTIMORESEN O1 02 03 02 04. FALL FALL WINTER2003 FALL SPRING 2004 2003 2003 C1 C2 C3 C2 C2 DB VB S1 S2 2003 VB VB S2 S3 StdSSN: Student's SSN StdCity: Student's address, StdClass: (freshman, sophomore, junior, senior), OfferNo: a unique number for each class, OffTerm; term in a year (semester), OffYear: year, EnrGrade: Grade, CourseNo: Course number, Crsdesc: Course description [2.1] Please find out all the candidate keys and then choose the primary key. (The primary key could be a composite key) [2.2] Please find all the functional dependencies. fdl: fd2: fd3: [2.3] Please find out the second normal form (in the format of relational schema) [2.4] Please find out the third normal form

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 Databases Questions!

PART 4: Given the following table and functional dependencies, construct tables below that will satisfy 2NF and identify the primary key of each new table. Note that the primary key of this table is...

Assignment #5 PART A StdSSN StdCity SI SEATTLE SI SEATTLE S2 BOTHELL S2 BOTHELL StdClass TUN JUN JUN JUN Offer No 01 02 03 02 OffTerm FALL FALL SPRING FALL OffYear 2006 2006 2007 2006 EnrGrade...

QUESTION 6 What query produces the same results as the one below? SELECT Student.StdNo, Student. StdFirstName, Student.StdLastName, Student.Std Major FROM Student WHERE NOT EXISTS (SELECT * FROM...

Please answer CLEARLY and LEGIBLE Also give SQL code when needed. Assume that the University designs a database with the following tables: (Primary keys underlined, foreign keys are in italics)...

Step by step working on powerBI List Bob Norberts course schedule in spring 2008. For each course, list the offering number, course number, days, location, time, and faculty name. List Bob Norberts...

Here is the P4 university database ---Drop tables --Drop Table FACULTY Cascade Constraints; --Drop Table OFFERING Cascade Constraints; --Drop Table STUDENT Cascade Constraints; --Drop Table COURSE...

Here is the P4 university Data Base ---Drop tables --Drop Table FACULTY Cascade Constraints; --Drop Table OFFERING Cascade Constraints; --Drop Table STUDENT Cascade Constraints; --Drop Table COURSE...

The Reliable Aircraft Company manufactures small, pleasure-use aircraft. Based on past experience, sales volume appears to be affected by changes in the price of the planes and by the state of the...

How do we know how much profit our business has earned?

Determine two (2) key ways in which Richard Branson is likely to motivate employees in order to achieve his goals for the Virginia group. Indicate whether or not his approach is likely to work in a...

The function of an investment bank may include all of the following except A ) distributing large blocks of stock to the public and to institutions. B ) advising corporations regarding the best ways...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...