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: 73% (15 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...
-
Lululemon sells athletic wear including tops, yoga pants, shorts, sweaters, jackets, and undergarments, as well as hair accessories, bags, yoga mats and water bottles, in retail stores and online....
-
A 2.5-in.-diameter flow nozzle meter is installed in a 3.8-in.-diameter pipe that carries water at \(160{ }^{\circ} \mathrm{F}\). If the air-water manometer used to measure the pressure difference...
-
Wedona Energy Consultants prepares adjusting entries monthly. Based on an analysis of the unadjusted trial balance at January 31, 2014, the following information was available for the preparation of...
-
What is its unit price? Let's think of a batch of 100 baked goods...what is its total price? Speculate how much is the cost to bake (AND sell) that 1 batch (100 units)? Calculate its related gross...
-
Unilever Inc. recently developed a new body wash with a scent of ginger. Their research indicates that 30% of men like the new scent. To further investigate, Unilevers marketing research group...
-
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.
-
You are a sales rep working for a college newspaper that has an online version. How would you attract advertising? One of your colleagues says there is no market for online advertising for the paper,...
-
Errors in trial balance Identify the errors in the following trial balance. All accounts have normal balances. Ensemble Co. Unadjusted Trial Balance For the Year Ending December 31, 20Y8 Debit Credit...
-
Multiply. 4 (x3 + x+x+1)(13x-2)
-
How can I create a map of Berlin with Rstudio? I would also like to create a linear regression with the NAO values and precipitation values. The precipitation values are monthly. Therefore, all NAO...
-
A computer program is said to learn from experience E with respect to some task T and some performance measure P if its performance on T , , as measured by P , , improves with experience E . ....
-
Sarasota Equipment Leasing Company leased equipment to Sunland Healthcare System on January 1, 2025, for a four-year period. Equal annual payments under the lease are $580000 and are due on January 1...
-
True or false: If true, explain why. If false, give an explicit counterexample. (a) If det 0 then A-l exists. (b) det(2A) = 2 det A. (c) det(A -(- B) = det A + det B. (d) (e) (f) det[(A + B)(A - B)]...
-
Write the statement to store the contents of the txtAge control in an Integer variable named intAge.
-
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.
-
2-Using the CPT data in figure below, a unit weight of 115 pcf, and an overconsolidation ratio of 3, determine (a) soil behavior type (b) o' using Kulhawy and Mayne correlation and (c) N60 for the...
-
How does the application of computational fluid dynamics (CFD) coupled with multiphase flow modeling enhance the understanding and prediction of complex hydrodynamic behaviors in industrial-scale...
-
1. From the joint distribution defined by the graphical model, determine if the conditional independence holds: ALL FIE, B, and provide brief explanation (5 points). 2. Given an undirected chain...
Study smarter with the SolutionInn App