A multinational company has offices (sites) in several cities. Each site has one or more departments...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A multinational company has offices (sites) in several cities. Each site has one or more departments (accounting, research, production, etc.). Every employee works at some site in a particular department. Every department at each site has a manager. Each employee undergoes an evaluation and the result of his or her evaluation is composed of 'grade' which is an integer between 0 and 10 for various criterion: efficiency, productivity, innovation, inter-personal relation etc. The schema is given as follows: (Primary keys are underlined and Foreign keys have same attribute names) Department (Dep_id, Dep_name) Site (Site_id, Site_name, City, Country) Site Department (Site_id, Dep_id) Manager (Site_id, Dep_id, Emp_id) Employee (Emp_id, start_date, Site_id, Dep_id, salary) Evaluation (Emp_id, C_id, grade) Criterion (C_id, C_name) 1. Write python code to create a database and the tables for the above schema. Assume appropriate data type for all attributes and specify primary and foreign key constraints. (8 points) A multinational company has offices (sites) in several cities. Each site has one or more departments (accounting, research, production, etc.). Every employee works at some site in a particular department. Every department at each site has a manager. Each employee undergoes an evaluation and the result of his or her evaluation is composed of 'grade' which is an integer between 0 and 10 for various criterion: efficiency, productivity, innovation, inter-personal relation etc. The schema is given as follows: (Primary keys are underlined and Foreign keys have same attribute names) Department (Dep_id, Dep_name) Site (Site_id, Site_name, City, Country) Site Department (Site_id, Dep_id) Manager (Site_id, Dep_id, Emp_id) Employee (Emp_id, start_date, Site_id, Dep_id, salary) Evaluation (Emp_id, C_id, grade) Criterion (C_id, C_name) 1. Write python code to create a database and the tables for the above schema. Assume appropriate data type for all attributes and specify primary and foreign key constraints. (8 points)
Expert Answer:
Related Book For
Finite Mathematics and Its Applications
ISBN: 978-0134768632
12th edition
Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair
Posted Date:
Students also viewed these databases questions
-
There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Determine A in the indicated figures. Fig. 2.40 (a) A 84 (a) 40 B
-
In the Preview section for this chapter, we discussed a research study demonstrating that 8-month-old infants appear to recognize which samples are likely to be obtained from a population and which...
-
For the pipe-flow reducing section of Fig P3.54, D1 = 8 cm, D2 = 5 cm, and p2 = 1 atm. All fluids are at 20°C. If V1 = 5 m/s and the manometer reading is h = 58 cm, estimate the total horizontal...
-
In Example 6.3, what is the change in the cart's kinetic energy due to the shove (a) in the Earth reference frame, (b) in a reference frame moving in the same direction as the cart at \(0.60...
-
Simkin's Hardware Store simulated an inventory ordering policy for Ace electric drills that involved an order quantity of 10 drills with a reorder point of 5. The first attempt to develop a...
-
Trying to break an encryption key by trying every possible combination of characters is called what? 1 point A social engineering attack A brute force attack A rainbow table attack A known cyphertext...
-
Explicitly consider the possibility of corner point solutions for mu that it might be equal to 0 or to 1 exactly. Apply KKT. (Note the variable here is mu, so you will have to use a different...
-
Jane is self-employed. Her recent adjusted trading profits/(losses) are: Jane has other income of 10,000 per annum. Assuming that the trading loss is carried forward and set against future trading...
-
On 1 June 2021, Stephen was provided by his employer with an interest-free loan of 20,000. He repays 5,000 of this loan on 1 January 2022 and repays another 3,000 on 1 March 2022. Compute the taxable...
-
In each of the following situations, determine in what state the person was domiciled at the time of death. a. While living in Illinois, Fred hears about a high-paying job in Alaska. He decides to...
-
An individual has capital losses brought forward from previous years amounting to 4,800. Compute the individual's taxable gains for 2021-22 if total gains and losses for the year are as follows:...
-
Rosemary's capital gains and losses in recent years (and the annual exemption for each year) have been as follows: There were no unrelieved losses to bring forward from 2017-18 or earlier. Compute...
-
Explain in detail the Analysis step of design process with and with-out use of computers.
-
Do the three planes x + 2x + x 3 = 4, X X 3 = 1, and x + 3x = 0 have at least one common point of intersection? Explain.
-
A plant supervisor must apportion her 40-hour workweek between hours working on the assembly line and hours supervising the work of others. She is paid $12 per hour for working and $15 per hour for...
-
Suppose that a price war reduces the profits of gasoline in Exercise 19 to $.05 per gallon and that the profits on jet fuel and diesel fuel are unchanged. How many gallons of each fuel should now be...
-
Two players, Robert and Carol, play a game with payoff matrix (to Robert) (a) Is the game strictly determined? Why? (b) Suppose that Robert has strategy [.7 .3]. The opponents agree that the game...
-
Satellite Radio Customers. An analyst at a subscription-based satellite radio company has been given a sample of data from their customer database, with the goal of finding groups of customers who...
-
Hair Care ProductUplift Modeling. This problem uses the dataset in Hair-CareProduct.csv, courtesy of SAS. In this hypothetical case, a promotion for a hair care product was sent to some members of a...
-
Identifying Course Combinations. The Institute for Statistics Education at Statistics.com offers online courses in statistics and analytics and is seeking information that will help in packaging and...
Study smarter with the SolutionInn App