Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A multinational company has offices (sites) in several cities. Each site has one or more departments (accounting, research, production, etc.). Every employee works at

image

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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finite Mathematics and Its Applications

Authors: Larry J. Goldstein, David I. Schneider, Martha J. Siegel, Steven Hair

12th edition

978-0134768588, 9780134437767, 134768582, 134437764, 978-0134768632

More Books

Students also viewed these Databases questions

Question

Determine A in the indicated figures. Fig. 2.40 (a) A 84 (a) 40 B

Answered: 1 week ago

Question

Did the parties reach an agreement that both were satisfied with?

Answered: 1 week ago