Question: Create the Relational Model for the Flubber database based on your ER Diagram, meeting all the same requirements. This should be syntactically correct to test

Create the Relational Model for the Flubber database based on your ER Diagram, meeting all the same requirements. This should be syntactically correct to test in a MySQL database.

1. Create an Entity-Relationship Diagram with the following requirements. (25 points) A. There are Professors (ie users) with the changeable attributes Professor_Name, Field, College,

1. Create an Entity-Relationship Diagram with the following requirements. (25 points) A. There are Professors (ie users) with the changeable attributes Professor_Name, Field, College, PhD_Date B. There are Flubs with the unchangeable attributes Content, Purpose, Moment, Inventor (which is the creating Professor) C. There are Bounces where a Professor can share another Professor's Flub D. Add ID attributes as necessary E. Content is only text of a fixed length for version 1.0 but should be expandable later F. Professors can have/be Colleagues G. A Flub can get Citations by other Professors

Step by Step Solution

★★★★★

3.50 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a picture of ER Diagram of given Relational data Model Now find the syntax ... 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 Databases Questions!

Create the Relational Model (write the DDL SQL script) for the Flubber database based on your ER Diagram, meeting all the same requirements. Include all necessary Primary Key and Foreign Key...

Despite these observations, DepEd is optimistic that these shortages and problems will be overcome as they claim that these are being addressed. Meanwhile, the Coordinating Council of Private...

Jim Watanabe, manager of the No Customer Escapes project, and assistant director of IT for Petrie Electronics, was sitting in the company cafeteria. He had just finished his house salad and was about...

A population of Ecuadorians have short stature. They have a rare genetic defect that affects the body's response to growth horm one, called Laron syndrome. Recent genetic studies have dem onstrated...

Franz Company was organized on January 1. During the first year of operations, the following plant asset expenditures and receipts were recorded in random order. Debits 1. Cost of real estate...

Income statement items Obj. 5 Based on the data presented in Exercise 1-16, identify those items that would appear on the income statement. AppendixLO1

In the first circuit of the last exercise, assume that the probabilities pi are all equal. What value should each pi be so that the probability of electricity transmission through the circuit is 99%?

Wilburton Riding Stables provides stables, care for animals, and grounds for riding and showing horses. The account balances at the beginning of 2009 were: Cash ....................$ 2,200 Accounts...

American Food Services, Inc., acquired a packaging machine from Barton and Barton Corporation. Barton and Barton completed construction of the machine on January 1, 2018. In payment for the $4.2...

The Triad family of mutual funds allows investors to split their money between three portfolios managed by Triad. Portfolio C has an expected return of E[R] 10% and a standard deviation of returns of...

Fogerty Company makes two products - titanium Hubs and Sprockets. Data regarding the two products follow: \ table [ [ Direct Labor - Hours per,, ] , [ Hubs , Unit,Annual Production ] , [ Sprockets ,...

Question 9 12 pts Each year about 1500 students take the Introductory statistics course at a large university. This year scores on the final exam are distributed with a median of 74 points, a mean of...

Solve 2 cos(x) - 3 cos(x) + 1 = 0 for all solutions 0

Assume that investor's care about the first four moments of the return distribution. Given the following information which investment would investors prefer? Stock A: Mean Return = 10%, Standard...

How is power divided between the Board of Directors, individual directors and shareholders? Why power is divided this way? Does this division of power create any issues? If so, for whom?

Consider the demand equation for University of Alberta hoodies p = -0.03x + 30.0 for 0 x 1000. This describes the relation between the hoodie price p in dollars and the amount of hoodies demanded....

What is the NPV of the following cash flows if the required rate of return is 0.07? Year 0 1 2 3 4 CF -7,181 3,126 2,121 2,446 4,989 Enter the answer with 2 decimals (e.g. 1000.23).

Propose a reasonable mechanism for the following reaction. OH

Q5. You are hired as a Project Manager to develop an Online Shopping System of Grand City Mega Mall. Summarize key work involved in each of the six processes of project integration management for...

Helen Jarvis wants to determine the most important customers for Home Office products. She requests a listing of total dollar sales year-to-date for each customer who bought these products, as...

How is the order in which attributes appear in a result table changed? How are the column heading labels in a result table changed?

List the nine major components in a database system environment.

Bienvenu Enterprises reported cost of goods sold for 2019 of $1,400,000 and retained earnings of $5,200,000 at December 31, 2019. Bienvenu later discovered that its ending inventories at December 31,...

PetroChina reported the following information in a recent annual report. Cash and Cash Equivalents. Cash and cash equivalents refer to all cash on hand and deposit held at call with banks, short-term...

Mills Company was formed on December 1, 2018. The following information is available from Mills' inventory records for Product Zone. A physical inventory on March 31, 2019, shows 1,500 units on hand....