Choose Oracle data types for the attributes in the normalized relations that you created in Problem and
Question:
Choose Oracle data types for the attributes in the normalized relations that you created in Problem and Exercise 19 in Chapter 4.
Data from Exercise 19.
Figure 4-35 includes an EER diagram for a medium-size software vendor. Transform the diagram into a relational schema that shows referential integrity constraints. In addition, verify that the resulting relations are in 3NF.
Transcribed Image Text:
EMPLOYEE Emp ID Emp Name Emp Type Belongs To REGION COUNTRY Country ID Country Name Region ID Region Name COUNTRY DEVELOPMENT DEVELOPER H MANAGER MANAGER H 0 Developer Type Manages Supervises Supervises ASSIGNMENT Score Hours Rate MEMBERSHIP Joined Left PROJECT TEAM Proj ID Proj Start Date Proj End Date Leads Team ID H Team Name Is Responsible For Team Start Date H SENIOR WIZARD Is Deputy Team End Date JUNIOR Mentors
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 63% (11 reviews)
Relation Attribute Oracle data type CommentsNotes REGION RegionID NUMBER150 RegionName VARCHAR250 Ch...View the full answer
Answered By
Nyron Beeput
I am an active educator and professional tutor with substantial experience in Biology and General Science. The past two years I have been tutoring online intensively with high school and college students. I have been teaching for four years and this experience has helped me to hone skills such as patience, dedication and flexibility. I work at the pace of my students and ensure that they understand.
My method of using real life examples that my students can relate to has helped them grasp concepts more readily. I also help students learn how to apply their knowledge and they appreciate that very much.
4.00+
1+ Reviews
10+ Question Solved
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
Question Posted:
Students also viewed these Computer science questions
-
Choose Oracle data types for the attributes in the normalized relations in Figure 5-4b. DBMS you are using is Oracle. If that is not the case, feel free to modify the question for the DBMS...
-
A start-up is working on an online personal financial management system. The goal of the system is to provide the users an opportunity to obtain item-level purchase data from as many sources as...
-
A bus company is responsible for offering public transportation in the suburbs of a large metropolitan area. The company has significant data management requirements: It needs to keep track of its...
-
Sandra, a sole proprietor, is an interior designer and has thefollowing account balances on December 31, 20X0: Cash $2,500,Inventory $9,000, Equipment $25,000, Accumulated depreciation$5,000, Liabi 2...
-
An investor owns a portfolio consisting of two mutual funds, A and B, with 35% invested in A. The following table lists the inputs for these funds. Measures Fund A Fund B Expected Value......10...5...
-
Use the data in file nhanes.dat for this exercise. (If you prefer, you may download the NHANES data from the website at www.cdc.gov/nchs/nhanes.htm.) Triceps skinfold measurements are sometimes used...
-
Find a video on deposition preparation that is available online. As a paralegal, how can you assist in preparing a client for deposition?
-
Monica Sexton filed a petition for Chapter 13 reorganization. One of her creditors was Friedmans Jewelers. Her petition misclassified Friedmans claim as $ 800 of unsecured debt. Within days,...
-
64. Johnson Marine has the following costs and expected sales for the coming year. Johnson is considering a number of different methods to determine the price of its product. Variable Manufacturing...
-
The owner of a private food store is concerned about employee morale. She decides to survey the employees to see if she can learn about work environment and job satisfaction. Obtain a simple random...
-
Because of referential integrity, before any row can be entered into the SECTION table, the CourseID to be entered must already exist in the COURSE table. Write an SQL assertion that will enforce...
-
Contrast the following terms: a. Physical file; tablespace b. Normalization; denormalization c. Range control; null control d. Secondary key; primary key
-
Write a curved-arrow mechanism for formation of the rearrangement product shown in Eq. 9.60. CH3 CH3 I T H3C-C- CH 3 -CH-Cl EtOH 80 C CH3 CH3 | I H3C-C- | OEt + -CH-CH3 EtOH Cl + other products...
-
B. Barnes is a dealer who has not kept proper books of account. At 31 October 2016 his state of affairs was as follows: During the year to 31 October 2017 his drawings amounted to 32,200. Winnings...
-
On 1 May 2015 Jenny Barnes, who is a retailer, had the following balances in her books: Premises 70,000; Equipment 8,200; Vehicles 5,100; Inventory 9,500; Trade accounts receivable 150. Jenny does...
-
Jean Smith, who retails wooden ornaments, has been so busy since she commenced business on 1 April 2015 that she has neglected to keep adequate accounting records. Jean's opening capital consisted of...
-
Bill Smithson runs a second-hand furniture business from a shop which he rents. He does not keep complete accounting records, but is able to provide you with the following information about his...
-
A summary of the Balgreen Bowling Club's cash book is shown below. From it, and the additional information, you are to construct an income and expenditure account for the year ending 31 December...
-
Give several examples of electromagnetic waves that are encountered in everyday life. How are they all alike? How do they differ?
-
As you rewrite these sentences, replace the cliches and buzzwords with plain language (if you don't recognize any of these terms, you can find definitions online): a. Being a jack-of-all-trades, Dave...
-
Assuming it is possible to sort n numbers in O(nlogn) time, show that it is possible to solve the three-way set disjointness problem in O(nlogn) time.
-
Describe an efficient algorithm for finding the ten largest elements in an array of size n. What is the running time of your algorithm?
-
Give an example of a positive function f (n) such that f (n) is neither O(n) nor (n).
-
For each of the following: identify all critical numbers and use these to determine all region(s) where the function is increasing as well as all region(s) where the function is decreasing. Then...
-
Determine the most suitable data structure for the above graph and show it adjacency representation. (5 markah/marks)
-
The table gives the outdoor temperatures observed by a science student on a spring day. Draw a graph of the data, and find the average rate of change of temperature between the following times: a)...
Study smarter with the SolutionInn App