Give an SQL schema definition for the employee database of Figure 3.19. Choose an appropriate domain for
Question:
Give an SQL schema definition for the employee database of Figure 3.19. Choose an appropriate domain for each attribute and an appropriate primary key for each relation schema. Include any foreign-key constraints that might be appropriate
Transcribed Image Text:
employee (ID, person_name, street, city) works (ID, company_name, salary) company (company_name, city) manages (ID, manager_id)
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 71% (14 reviews)
CREATE TABLE employee ID INT NOT NULL personname VARC...View the full answer
Answered By
Kenneth Mutia
I have a B.S. in Statistics from the Jomo Kenyatta University of Agriculture and technology. I have been an academic tutor for over 3 years. I have a passion for helping students reach their full potential and am dedicated to helping them succeed. I am patient and adaptable, and I have experience working with students of all ages and abilities, from elementary school to college in their various fields. I have a wide scope of diverse tutoring experience in several courses of study with significant success as a tutor.
0.00
0 Reviews
10+ Question Solved
Related Book For
Database System Concepts
ISBN: 9780078022159
7th Edition
Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan
Question Posted:
Students also viewed these Computer science questions
-
Give an SQL schema definition for the employee database of Figure. Choose an appropriate domain for each attribute and an appropriate primary key for each relationschema. employee (employee-name,...
-
Consider the employee database of Figure 3.19. Give an expression in SQL for each of the following queries. a. Give all employees of First Bank Corporation a 10 percent raise. b. Give all managers of...
-
Consider the employee database of Figure, where the primary keys are underlined. Give an expression in SQL for each of the following queries. a. Find the names of all employees who work for First...
-
Below is list of ethical principles that a business might follow. Think of a situation where following each might not necessarily be the right thing. a. Follow contracts to the letter. b. Never...
-
Base your answers to the following questions on the 2009 financial statements for Michelin Group in Exhibit 1-8. This international French company manufactures and sells tires. In Exhibit 1-8...
-
Consider the following partially completed two way ANOVA summary table: a. Complete the remaining entries in the table. b. How many replications are present for each cell? c. Using = 0.05, is there...
-
What is an advantage of calculating all three measures of central tendency?
-
The model for making tactical decisions described in the text has six steps. These steps are listed, out of order, below. Required: Put the steps in the correct order, starting with the step that...
-
After watching the movie(Enron- the smartest guys in the room) and also the clip of Milton Friedman discussing Greed, what are your thoughts on the difference of "free markets" vs. regulations in...
-
The Brunswick Research Organization surveyed 50 randomly selected individuals and asked them the primary way they received the daily news. Their choices were via newspaper (N), television (T), radio...
-
Show that, in SQL, all is identical to not in.
-
Rewrite the where clause where unique (select title from the course) without using the unique construct.
-
For each of the following m x n matrices, decompose the first standard basis vector e1 = w + z Rn, where w corng A and z ker A. Verify your answer by expressing w as a linear combination of the rows...
-
1. Briefly introduce your selected company and describe the industry. I don't need a history of the company or a discussion of strategies at this stage. This should be no longer than a few...
-
Shows there is anopportunity for further developmentand recommend reading and studying more about Emotional Intelligence. Emotional Intelligence and to develop your EI skills for future leadership...
-
1) Last week, your cafe sold 3,000 cups of coffee. Demand is expected to decrease by 10% for every 5% increase in price. Your current price is $2.80 and you are considering raising your price to...
-
Describe the business and operational challenges facing Bergerac Systems. Should Bergerac Systems integrate backwards into the manufacture of injection-molded parts for its cartridges? What are the...
-
A beer distributor sells 500 cases of regular 12-oz. Budweiser per week for 50 weeks each year - assume that there are 50 weeks in a year - from its warehouse in Central Austin. The distributor...
-
Sly asks Andy to play a game with him. They each roll a die. If the sum is greater than 7, Andy scores 5 points. If the sum is less than 8, Sly scores 4 points. a. Find a friend and play the game ten...
-
Refer to Example 9.15. Add the following functionality to this program: Allow the user to enter the cost of a gallon of gas on each trip and use a function, Cost() to calculate the cost of purchasing...
-
SQL allows a foreign-key dependency to refer to the same relation, as in the following example: create table manager (employee-name char (20), manager-name char(20), primary key employee-name,...
-
Suppose there are two relations r and s, such that the foreign key B of r references the primary key A of s. Describe how the trigger mechanism can be used to implement the on delete cascade option,...
-
Write an assertion for the bank database to ensure that the assets value for the Perryridge branch is equal to the sum of all the amounts lent by the Perryridge branch.
-
A manufacturer reports the information below. Finished goods inventory, beginning Finished goods inventory, ending Depreciation on factory equipment Direct labor Indirect labor Factory utilities...
-
Pallette Manufacturing received an invoice dated, March 28 with terms 3/15, n/30. The amount stated on the invoice was $2008.00. (a) What is the last day for taking the cash discount? (b) What is the...
-
Pie Corporation acquired 75 percent of Slice Company's common stock on December 31, 20X5, at underlying book value. The book values and fair values of Slice's assets and liabilities were equal, and...
Study smarter with the SolutionInn App