Consider the following relational database: employee (employee-name, street, and city) works (employee name, company-name, salary) company (company-name,

Question:

Consider the following relational database:

employee (employee-name, street, and city)

works (employee name, company-name, salary)

company (company-name, city)

manages (employee-name, manager name)

Give an SQL DDL definition of this database. Identify referential-integrity constraints that should hold, and include them in the DDL definition.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Database System Concepts

ISBN: 978-0072554816

4th Edition

Authors: Henry F. Korth, S. Sudarshan

See More Books

Question Posted: Jan 28, 2011 05:54 AM

See More Questions

1. Which command creates a new table? 2. Which command and clause adds an individual row to a table? 3. How do you add data from an existing table to another table? 4. Which command changes data in a...
Consider the following relational database that Best Airlines uses to keep track of its mechanics, their skills, and their airport locations. Mechanic number, airport name, and skill number are all...
Consider the following relational schema and SQL query. The schema captures information about employees, departments, and company finances (organized on a per department basis). Emp(eid: integer,...
You are an information technology (IT) intern working for Health Network, Inc. (Health Network), a fictitious health services organization headquartered in Minneapolis, Minnesota. Health Network has...
Hopper Travel uses the contribution margin income statement internally. Hopper's second-quarter results are as follows: Hopper's relevant range is sales of between $100,000 and $640,000. Requirements...
The Sports Equipment Company produces a wide variety of sports equipment. Its newest division, Golf Technology, manufactures and sells a single product- AccuDriver, a golf club that uses global...
Define outsourcing and offshoring. Compare and contrast the two as HR administrative tools. Give examples of the decision factors to consider when choosing one over the other.
1. What are two main concerns that MNCs should evaluate when doing business in Russia? 2. How can MNCs protect themselves from government action? 3. What proactive political strategies might help...
Use the Following metrics to perform the operation, if possible. A = F2-12 1 3 0 1 2 3 B 1 1 2 3 5 3-3 L0323 Find 2A-3B
A company has four project investment alternatives. The required rate of return on projects is 20%, and inflation is projected to remain at 3% into the foreseeable future. The pertinent information...
Complete the SQL DDL definition of the bank database of Figure to include the relations loan andborrower. create table customer (customer-name char(20), customer-street char(30), customer-city...
Referential-integrity constraints as defined in this chapter involve exactly two relations. Consider a database that includes the following relations: salaried-worker (name, office, phone, salary)...
Three independent situations follow: 1. Second Time Around Corp. (STAC) issued $7,000,000 in stripped (zero-coupon) bonds that mature in eight years. The market rate of interest for bonds of a...
How should ethics influence employee attitudes and morale? How does the ethical code of conduct and behavior at your organization influence employee morale and business performance? Provide specific...
(3) The substitution reaction below for Pt(Ph)2(Me2S)2 gives the activation parameters AH* = 101 kJ mol and AS* = +42 J mol K. Propose a mechanism for this reaction and explain how your mechanism is...
Discuss the importance of communication during organizational change. Describe two effective communication strategies for communicating change that are relevant to internal and external stakeholders.
. From the graph shown to the right, determine a) The displacement from t=15s to t=55s b) The acceleration from t-15s to t=40s Velocity (m/s) 80 60 40 20 -20 -40 10 20 30 40 50 time (sec)
Acneity & Activity Based Costing Timber Mart (TM) has a furniture manufacturing plant that uses activity-based costing. The system has the following activities: Allocation Rate Activity Purchasing...
Profile Model. Using the information from the profile model in Problem 3.18, construct an argument as to why project B is preferable to project C. Problem 3.18 Profile Model. Assume the project...
Shreemaya Hotel in !adore was facing a problem of low demand for its rooms due to off season. The Managing Director (MD) of the hotel, Mrs. Sakina was very worried. She called upon the Marketing...
The elementary liquid-phase reaction AB,k1k1=1.0 min1 is carried out in a packed-bed reactor in which dispersion is present. What is the conversion? Additional information: Porosity = 50% Particle...
Fill in the blanks below to complete the following Apache Spark program which computes the number of occurrences of each word in a file. For simplicity we assume that words only occur in lowercase,...
What is the conceptual problem with the following snippet of Apache Spark code meant to work on very large data. Note that the collect() function returns a Java collection, and Java collections (from...
Give pseudocode for computing a join r r. A=s. A s using a single MapReduce step, assuming that the map() function is invoked on each tuple of r and s. Assume that the map() function can find the...
1. Raman purchases a motor car from Bharathan whose cash price is Rs. 56,000 on 11.93. Rs. 15,000 is paid on signing the contract and the balance is to be paid in three equal annual instalments of...
Write a function that takes in a value x, a value el, and a list and adds as many el's to the end of the list as there are x's in the list. Make sure to modify the original list using list mutation...
Our office building has a total square footage of 120,000 square feet.We have 9 tenants in the building and no vacancies.The total square footage of the tenant spaces is 105,000.A) What is the Load...

Consider the following relational database: employee (employee-name, street, and city) works (employee name, company-name, salary) company (company-name,

Question:

Step by Step Answer:

Create table employee personname char20 street char30 city c...View the full answer

Database System Concepts

Students also viewed these Computer Sciences questions