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...
-
Is the firm in Question 3 a perfectly competitive firm? Explain your answer. Firm X Firm Y Firm Z Cost of eliminating: First ton of pollution Second ton of pollution $200 $500 $1,000 300 700 2,000...
-
Following is partial evidence from an audit working paper: Required: 1. What is the evidence attempting to detect? 2. Did it? Why or why not? Disbursement Date Receipt Date Per Per Per Per Books Bank...
-
Marinette Company makes several products, including canoes. The company has been experiencing losses from its canoe segment and is considering dropping that product line. The following information is...
-
1. Create a general production cost analysis table. *Please note that the insurance for employees is calculated at 2% of the total salary. 2. Calculate the overhead rates for processes A and B. 3....
-
A helium balloon hovers in midair, neither ascending nor descending. Is it in equilibrium? What forces act on it?
-
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
-
Use the Chain Rule to evaluate the partial derivative at the point specified. h at (q, r) = (3, 2), where h(u, v) = ue', u = q, v = qr
-
Two oscillatory motions are given by \(x(t)=A \sin (m \omega t)\) and \(y(t)=A \sin (n \omega t+\phi)\), where \(m\) and \(n\) are positive integers. Consider displaying these motions on a single...
-
Write a short commentary on each ledger account prepared in S1, to enable a nonaccountant to understand their purpose and content. Data from S1 Prepare ledger accounts to report the transactions and...
-
A tree that is \(32.6 \mathrm{~m}\) tall leans \(26.0^{\circ}\) from the vertical in the Farth reference frame. How tall is the tree, and at what angle does it lean, in the reference frame of a...
-
By what factor does the inertia of an electron increase (a) as the electron is accelerated from rest to \(\frac{1}{3} c_{0}\) and \((b)\) as its speed is increased by another \(20 \%\) ? (c) Does the...
-
A spacecraft traveling away from Earth at relative speed \(0.850 c_{0}\) sends a radio message when it is \(65,000,000 \mathrm{~km}\) away from Earth in the Earth reference frame. When the signal is...
-
In parts (a) and (b) sketch isoclines f (x, y) = c for the given differential equation using the indicated values of c. Construct a direction field over a grid by carefully drawing lineal elements...
-
You've been asked to take over leadership of a group of paralegals that once had a reputation for being a tight-knit, supportive team, but you quickly figure out that this team is in danger of...
-
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).
-
Design a power transmission system to connect a DC motor to its load. The motor is given in the motor catalogue as a BM1400 motor. You must create a transmission which will connect to this motor and...
-
SDJ, Incorporated, has net working capital of $3,320, current liabilities of $4,550, and inventory of $4,600. a. What is the current ratio? b. What is the quick ratio?
-
Calculate the final selling price to the nearest cent and markdown percent to the nearest hundredth percent: Original selling price $4,900 First markdown 20% Second markdown 10% Markup 12% Final...
Study smarter with the SolutionInn App