Question: Consider just the STUDENT relation from DAYCARE . The relation has several functional dependencies. We can guess what they are by looking at the data

Consider just the STUDENT relation from DAYCARE. The relation has several functional dependencies. We can guess what they are by looking at the data and the requirements. One functional dependency is problematic because it violates a normal form.

a. What is the problematic functional dependency?

b. What type of functional dependency is it?

c. What normal form does the functional dependency violate?

d. Normalize the relation so that it is in third normal form (3NF). Write out the schemas for all resulting tables (no data, just schemas). Indicate all primary keys by underlining and all foreign keys with arrows.

e. Suppose a new student named Thandi enrolls in the daycare. She is 3 years old in classroom B. Her phone number is (355) 672-2755. What row or rows would you add to the database for the new student, considering your new schemas?

Screen Shot 2020-11-22 at 4.57.51 PM.png

Screen Shot 2020-11-22 at 4.15.26 PM.png

STUDENT Name Age Phone Classroom Gretta 4 (737) 588-6641 C Allena 5 (664) 781-2513 C Eden 4 (897) 765-5734 C Lessi 2 (419) 494-3145 A Shizue 2 (224) 997-3320 Joy 3 (480) 916-3046 AB

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!

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

CANMNMM January of this year. (a) Each item will be held in a record. Describe all the data structures that must refer to these records to implement the required functionality. Describe all the...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Consider the Grade Report Relation with the composite Primary Key: Student_Id and Course_Id. Note each course is taught by one Instructor and each Instructor has one Instructor_Location. An...

The company is organized into departments. Each department has a name, a number, and an employee who manages the department. We keep track of the start date when that employee started managing the...

BITS Corporation exercises 3-5 poly dent tudent Cou Tacuity student Faculty dente. Se esta Student to Describe the entity su s ulty traculty R um) the relationship between columns that can be u 11....

PLEASE READ CAREFULLY THE CASE STUDY PROVIDED AND FEEL FREE TO ADD HERE YOUR COMMENTS FOR EXAMPLE LIKES DISLIKES WORDS OR PHRASES YOU DO NOT UNDERSTAND ANY COMMENTS THAT WILL IMPROVE THE DIALOGUE...

Subaru Motors Corporation (SMC) today announced plans to revise its organisational structure. The changes will see the company's structure slim down from 230 departments to 131, which will hopefully...

Chapter 2 The Origins of Software Chapter Overview Make an overview of the primary purposes of this chapter. What is the main concept introduced in this chapter? What kind of strategies should...

Complete the Bits Corporation exercises 1-6 containing red Advisorricum A of y. nasional and that 1. Comment and **. The following spendencies b pendencies that is a ble to an equivalent ie to an...

Why doesn't the cutting force Fc increase with increased speed V?

Answer the questions below to demonstrate your knowledge of testing and optimising marketing performance. When answering the questions, make sure you: Answer all parts of each question Use your own...

Select the basis of accounting most often used for each section of a Basic Financial Statement ( BFS ) . a ) Government - wide Funds. [ Select ] [ " Modified accrual basis of accounting", "Cash basis...

Lynne Duggan, age 16 is a summer student working part-time for a wrestling magazine in Manitoba. This is her first job, and has not paid any CPP or EI. Lynne works 14 hours per week at a rate of...

Fortune Cookie Inc. (FCI) issued $10 million of 10-year, 5% convertible bonds on April 1, Year 5 at 102.5 Coupons are payable on April 1 and October 1. Bonds without conversion privileges would have...

Read the case study McRoy Aerospace and answer the following questions: What should Mark have done if Jack still was not able to resolve the problem? Would it make sense for Mark to assign this...

Ann is a recent engineering graduate with two years experience in her current role and is currently looking at getting a Masters degree. She is currently paid $60,000 per year, which she expects to...

The following balances were extracted from the trial balance of Bell Crest Ltd on 30 June 2020: Additional information R Land at cost - 800 000 Buildings at cost - 1 200 000 Plant and machinery at...

6 Theory of Machines 5. A shaft carries five masses A, B, C, D and E which revolve at the same radius in planes which are equidistant from one another. The magnitude of the masses in planes A, C and...

Who are your entrepreneurial role models? Can you foster any of them into mentors?

Many Web sites offer legal form templates (e.g., shareholder agreements). Studying these templates helps you talk with your lawyer and can reduce your legal fees (time spent with lawyers), especially...

Refine your projections. Who can you talk to that is knowledgeable about your business (customers, vendors, competitors)? What secondary sources can you find (BizMiner.com, Google.com/finance)?

A sample space consists of five simple events with P(E1) = P(E2)=.15, P(E3)= .4, and P(E4)=2P(E5). 12. Find the probability of event A = {E,, E, E}.

A sample space contains seven simple events: E1 , E2 , . . . ,E7 . Suppose that E1 , E2 , . . . ,E6 all have the same probability, but E7 is twice as likely as the others. Find the probabilities of...

Experiment III A sample space consists of S={E1, E2, E3,E4 }. List the simple events in "both A and B," "A or B or both," and "not B" for the events given 14. A={E,E} and B={E,E,,E}