For each question below, develop a relational schema clearly showing the tables, primary key/s, foreign key/s,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For each question below, develop a relational schema clearly showing the tables, primary key/s, foreign key/s, and maximum cardinality constraints on both sides of each linkage (as shown in class). Note: we assume that both the phone number and the email can have a missing value. phone emall DOB first Im Id d le. stre e t ame CUSTOMER address las t city s ta te zip ID age a) The ER diagram below shows the relationship among several entities, i.e., the museum, the art objects displayed by the museum, the clients who buy the art objects, and the artists who create the art objects. The art objects fall into two subtypes, paintings and sculpture. Please convert this conceptual ER diagram to a relational schema. name email Caddress type 10 description type year created title "P" PAINTING style CLIENT buys ART O BJECT material draw n D type displayed at material "S" SCULPTURE height created by weight stre et advertised by person- in-charge city Caddress MUSEUM name ARTIST date born state zip name date died country main style total Part 2 Suppose we have a relation shown below with the data describing how employees are assigned to different projects and receiving different hourly charge (ChgHour) per hour according to their job class (JobClass). The relation also shows the number of hours each employee works on a project. Assume that there are dependencies among different attributes (as shown below). The example data in the relation is given below. ProjNum (i.e., Project Number) and EmpNum (Employee Number) constitute the composite primary key for the relation. ProjNum Proj Name EmpNum Example data in the given relation: EmpNum 103 101 ProjNum ProjName 15 Evergreen 15 Evergreen 15 Evergreen 22 27 Rolling Tide Starfight 105 105 104 EmpName JobClass EmpName June E Arbough John G News Alice K Johnson Alice K Johnson Anne K Ramoras JobClass Electrical Engineer Database Designer Database Designer Database Designer Systems Analyst Please convert the relation above to a 3NF relational schema. ChgHour ChgHour $84.50 $105.00 $105.00 $105.00 $96.75 Hours Hours 23.8 19.4 35.7 30 20.4 For each question below, develop a relational schema clearly showing the tables, primary key/s, foreign key/s, and maximum cardinality constraints on both sides of each linkage (as shown in class). Note: we assume that both the phone number and the email can have a missing value. phone emall DOB first Im Id d le. stre e t ame CUSTOMER address las t city s ta te zip ID age a) The ER diagram below shows the relationship among several entities, i.e., the museum, the art objects displayed by the museum, the clients who buy the art objects, and the artists who create the art objects. The art objects fall into two subtypes, paintings and sculpture. Please convert this conceptual ER diagram to a relational schema. name email Caddress type 10 description type year created title "P" PAINTING style CLIENT buys ART O BJECT material draw n D type displayed at material "S" SCULPTURE height created by weight stre et advertised by person- in-charge city Caddress MUSEUM name ARTIST date born state zip name date died country main style total Part 2 Suppose we have a relation shown below with the data describing how employees are assigned to different projects and receiving different hourly charge (ChgHour) per hour according to their job class (JobClass). The relation also shows the number of hours each employee works on a project. Assume that there are dependencies among different attributes (as shown below). The example data in the relation is given below. ProjNum (i.e., Project Number) and EmpNum (Employee Number) constitute the composite primary key for the relation. ProjNum Proj Name EmpNum Example data in the given relation: EmpNum 103 101 ProjNum ProjName 15 Evergreen 15 Evergreen 15 Evergreen 22 27 Rolling Tide Starfight 105 105 104 EmpName JobClass EmpName June E Arbough John G News Alice K Johnson Alice K Johnson Anne K Ramoras JobClass Electrical Engineer Database Designer Database Designer Database Designer Systems Analyst Please convert the relation above to a 3NF relational schema. ChgHour ChgHour $84.50 $105.00 $105.00 $105.00 $96.75 Hours Hours 23.8 19.4 35.7 30 20.4
Expert Answer:
Answer rating: 100% (QA)
The image you sent shows a diagram of a merge sort recursion tree Each node in the tree represents a subproblem of sorting a smaller and smaller array ... View the full answer
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these accounting questions
-
Myron Sheu, the owner of the Chocolate Outlet Store wants to forecast chocolate demand. Demand for the preceding four years is shown in the following table: Year 1 Demand (Pounds) 68,800 2 71,000 3...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Thomas Gilbert and Susan Bradley formed a professional corporation called Financial Services Inc.A Professional Corporation, each taking 50 percent of the authorized common stock. Gilbert is a CPA...
-
Find the nth derivative of the function f(x) = xn / (1 x).
-
What are Apple Inc three subsystems in human resource management?
-
a. Beginning with the score function for the logit case in equation (11.5), show that the information matrix can be expressed as \[\mathbf{I}(\boldsymbol{\beta})=\sum_{i=1}^{n} \sigma_{i}^{2}...
-
A vending machine is programmed to count out the correct change for each transaction. Formulate and solve an IP model that will determine how change is to be made for a purchase of $4.43, when a $10...
-
What are the influence tactics Managers choose ?
-
On Monday morning, you have $3000 in cash on hand. For the next seven days, the following cash requirements must be met: Monday, $5000; Tuesday, $6000; Wednesday, $9000; Thursday, $2000; Friday,...
-
Write in surd form and rationalize 1+Tan 30/1- Tan 30 Leaving your answer in the form of a+bC
-
For the real - time systems in Exercise 1.2, what are reasonable response times for all those events? Data from Exercises 1.2 Discuss whether the following are hard, firm, or soft real - time...
-
Most companies use the indirect method of preparing a cash flow statement. You are invited to meet a finance director of a leading listed company which uses the indirect method. Suggest two arguments...
-
A control system is measuring its feedback quantity at the rate of 100 s. Based on the measurement, a control command is computed by a heuristic algorithm that uses complex decision making. The new...
-
In what specific ways would trade among nations complicate the effort to construct an environmentally adjusted sustainable national income accounting? Explain.
-
Why are the negative externalities associated the newly opened Barclays Centre in Brooklyn likely to be greater than the negative externalities associated with the Staples Center in Los Angeles,...
-
Explain Gantt bar chart with suitable example with its limitations. What Is a Gantt Chart?
-
A test car is driven a fixed distance of n miles along a straight highway. (Here n Z+.) The car travels at one mile per hour for the first mile, two miles per hour for the second mile, four miles...
-
Incremental logging with deferred updates implies that the recovery system must a. Store the old value of the updated item in the log b. Store the new value of the updated item in the log c. Store...
-
Consider the UNIVERSITY EER schema in Figure 4.10. Think of what operations are needed for the entity types/classes in the schema. Do not consider constructor and destructor operations. Figure 4.10...
-
Discuss user-defined and predicate-defined subclasses, and identify the differences between the two.
-
When randomly selecting a day of the week, it is certain that you will select a day containing the letter y, so P(y) = 1. For Exercises 510, decide whether the statement makes sense (or is clearly...
-
If there is a 0.9 probability that it will rain sometime today, then there is a probability of 0.1 that it will not rain sometime today. For Exercises 510, decide whether the statement makes sense...
-
What do we mean when we say that the probability of getting 20 babies of the same gender when 20 random babies are born is 1/524,288? Is such an event unusual? Why or why not?
Study smarter with the SolutionInn App