Question: STUDENT Relation S SID S NAME 100 JONES 150 PARKS 200 BAKER 250 GLASS 300 BAKER 350 RUSSELL 400 RYE 450 JONES ENROLLMENT Relation

STUDENT Relation S SID S NAME 100 JONES 150 PARKS 200 BAKER 250 GLASS 300 BAKER 350 RUSSELL 400 RYE 450 JONES Question 2 Consider the following series of relations that keeps track of the enrollment of students in

STUDENT Relation S SID S NAME 100 JONES 150 PARKS 200 BAKER 250 GLASS 300 BAKER 350 RUSSELL 400 RYE 450 JONES ENROLLMENT Relation E_SNUM E CLASS 100 BD445 150 BA200 200 BD445 200 CS250 300 CS150 400 BA200 400 BF410 400 CS250 400 CS150 400 BD445 450 BA200 450 EN430 450 IE520 CLASS Relation C_NAME C_TIME C_ROOM --=== BA200 M-F9 SC110 BD445 MWF3 SC213 BF410 MWF8 SC213 CS150 MWF3 EA304 CS250 MWF12 EB210 S_MAJOR S GRADELEVEL GR HISTORY ACCOUNTING SO MATH GR HISTORY SN ACCOUNTING SN MATH JR ACCOUNTING FR HISTORY SN E POSITIONNUMBER 1 1 T3wwNNHNHHNH 2 1 2 2 Question 2 Consider the following series of relations that keeps track of the enrollment of students in classes. Page 4 contains sample data for these relations. STUDENT (S_SID, S_NAME, S MAJOR, S GRADELEVEL) ENROLLMENT (E SNUM. E CLASS, E POSITIONNUMBER) CLASS (C_CLASS, C_TIME, C_ROOM) 1. Specify the foreign key(s) that appear in this series of relations stating any assumptions you make. Be sure to include in your answer the relation(s) that contain foreign keys. 2. Use the information in these relations to "reverse engineer" (draw) the entity-relationship diagram that led to the creation of these three relations. You may assume that not all students enroll in classes and that at least one student is enrolled in each class. 3. The highlighted rows in the ENROLLMENT relation contain what type of violation? What would be required to eliminate this violation?

Step by Step Solution

★★★★★

3.39 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Im unable to complete this task as it involves drawing an entityrelationship diagram ERD which requires visual representation capability However I can ... View full answer

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

Question 5: For a special 3-payment whole life insurance on (50): i) ii) iv) v) vi) Premiums are P at the beginning of year 1, 2, and 3. Death benefit is paid at the end of the year of death. If...

Create a class named Account that contains: A private int data field named id for the account (default 0). A private double data field named balance for the account (default 0). A private double data...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Use the definitions e-ex sinh x 2 e* + ex cosh.x 2 and the Maclaurin series for e* to show that (a) sinh x=2 x2n+1 =0 (2n+1)! (b) cosh x= 0 (2n)! 50. Use the formula tanh x=- In +x -1

Database systems(help needed urgently) thanks. Enrollment SIDSName SID CCode Midterm Final Total 100 Jones 100 BD445 70 77 150 Parks 150 BA200 65 89 200 Baker 93 Student Major Year Age History GR 21...

Enrollment SIDSName SID CCode Midterm Final Total 100 Jones 100 BD445 70 77 150 Parks 150 BA200 65 89 200 Baker 93 Student Major Year Age History GR 21 Accounting | so 19 Math GR 50 History SR 50...

Database systems(help needed urgently) thanks. Enrollment SID CCode Midterm Final Total 100 BD445 70 77 CCode 150 BA200 65 89 BA200 Course CTime Room Nbrst Avg Total MWF9 SC110 3 MWF3 SC213 3 MWFB...

SQL Opportunity No . 2 The purpose of this exercise is to give you an opportunity to practice using SQL * Plus to create, most likely edit, and execute SQL queries. As you did on SQL Starter...

IGH 000018 Regular Student Report 2 Student ID 3 Teacher 4 Average Fee 5 Skill Level 6 Total Lessons 7 Total Paid this Year 8 Bonus Lessons Competiton Fees Registration Type Travel Type Uniform Size...

Module 6 Statistical Tests Solutions Geremy Gully PSY-845/Dr. Bielek Researchers wanted to explore self-esteem in adolescent boys and adolescent girls. Each respondent completed a 10-item self-esteem...

Evaluate the integral to find f2, the p.d.f. for S2. Suppose T1, T2, T3... are i.i.d. exponentially distributed random variables with = 1.0 and that Let fn be the p.d.f. for Sn. S,- Sn

3. A man, mass M, stands on a massless rod which is free to rotate about its center in the horizontal plane. The man has a gun (massless) with one bullet, mass m. He shoots the bullet with velocity...

Question 2 In 2 0 0 9 , a 3 0 second Super Bowl commercial spot sold for 2 . 6 million. True False

The internal path length of a full binary tree is the sum, taken over all internal nodes of the tree, of the depth of each node. Likewise, the external path length is the sum, taken over all leaves...

Follow the instructions for starting C++ and viewing the SwatTheBugs22.cpp file, which is contained in either the Cpp8\Chap08\SwatTheBugs22 Project folder or the Cpp8\Chap08 folder. (Depending on...

A man who has been sitting by his wifes side since she slipped into a coma is weary and has neither eaten nor slept for over 24 hours. You approach him with an I-message expressing your concern and...

To collect information such as passwords, online criminals use spoofing to direct Internet users to fraudulent websites. In one study of Internet fraud, students were warned about spoofing and then...

Discuss the building materials used by the three little pigs (straw, sticks, and bricks). Why were they chosen? Why did they fail? What was the environmental impact?

In JIT production, the principle "Produce to ____ Customer Demand" emphasizes making products only when they are needed.

These data give the amount of CO2 produced in 40 nations along with the level of economic activity, both in 2009. CO2 emissions are given in millions of metric tons. Economic activity is given by the...

The contingency table in Exercise 40 shows counts of the sizes of shirts bought in three styles in a retail store. (a) Find the value of chi-squared and Cramers V for this table. (b) Interpret these...

Emerald Diamonds These data are a subset of the diamonds used in Chapter 19. This data table of 144 diamonds includes the price (in dollars), the weight (in carats), and the clarity grade of the...

Suppose it is the beginning of 2008 and you are trying to assist the forecaster in Case New Holland, an international agricultural and construction equipment manufacturer, forecast total agricultural...

An analyst must decide between two different forecasting teclmiques for weekly sales of inline skates: a linear trend equation and the naive approach. The linear trend equation is yt = 124 + 2t, and...

Federated Cooperatives Limited (FCL) is the largest wholesaler of grocery, hardware, and agricultural supplies in Western Canada, and operates warehouses in Saskatoon, Edmonton, Calgary, and...