# Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission:...

###### Question:

Lab 4 – Logical Design

Introduction: This lab is designed to practice database design concepts.

Submission: For the scenario below, draw a logical design draft on the paper, and then draw the design in the computer using PG Modeler software. After that, export the model to PNG photo. Submit to Brightspace a word file that has a photo of the draft design (on the paper) and the PNG photo that is produced from the PG modeler.

Database scenario: Assume that you were appointed by a multi-national company to design a database for them. The database is required to store data about the employees of the company. For the employee, its required to have the employee ID, name, specialization and age. While, for the department, its required to have the department ID, Name, and manager. Regarding the branch, its required to have branch ID, Name, Telephone and location. However, for the project, its required to have the project ID, name, location and manager. At the same time, its required for the customer to have the customer ID, Name, and contact Info. In addition, for the supplier its required to have the supplier ID, name and contact Info. The department can have many employees but the employee can be assigned to one department only. Each branch can have many departments but the department can be assigned to one branch only. The department can have many projects and the project can be assigned to many departments. Each employee can have many customers but the customer can be assigned to one employee only. The supplier can supply many projects and the project can be supplied by many suppliers.

#### Similar Solved Questions

##### With the completion of the determinations of % potassium, % iron, and % oxalate in the...
With the completion of the determinations of % potassium, % iron, and % oxalate in the crystals, you may calculate the % water. The percentage compositionof the crystals, KxFe(C2O4)y · zH2O, has then been completely determined experimentally. The simplest formula (x,y,z) can now be calculated...
##### La Sim Manufacturing Company provided the following information for the year 2019 Inventories Direct Materials Work-in-Process...
La Sim Manufacturing Company provided the following information for the year 2019 Inventories Direct Materials Work-in-Process Finished Goods 31/12/2018 31/12/2019 $84,000$60,000 26,000 54,000 94,000 89.000 Other information: Sales Revenue Raw materials purchased Direct labor Indirect materials Pla...
##### Answer is not option "A" or option "B" 11.10 3 What is a major product of...
answer is not option "A" or option "B" 11.10 3 What is a major product of the following reaction? KOH, H2O ?. hy heat B) A) C) D)...
##### QUESTION 19 Which of the following is included in the investment component of GDP? a. purchase...
QUESTION 19 Which of the following is included in the investment component of GDP? a. purchase of a house by Maya which was build in 2017. b. the market value of semi finished goods. O production by an American company outside the U.S. Od market value of the finished goods which are not yet sold QUE...
##### List three attitudes of management that can inhibit the establishment of a high standard of customer service and explain each briefly in your own words
List three attitudes of management that can inhibit the establishment of a high standard of customer service and explain each briefly in your own words....
##### Evaluate the integral below by interpreting y=f(x) it in terms of areas in the figure. A1...
Evaluate the integral below by interpreting y=f(x) it in terms of areas in the figure. A1 АЗ The areas of the labeled regions are 10 31 5 A2 7A4 10 A1= 7, A2=4, A3=2 and A4=2 (figure is NOT to scale) v= 5.5" f(a)de V = Enter your answer as a whole number...
##### Nment CALCULATOR PRINTER VERSSON BA. In the month of March, Sarasota Salon services 620 dlients at an average price...
nment CALCULATOR PRINTER VERSSON BA. In the month of March, Sarasota Salon services 620 dlients at an average price of $200. During the manth, fixed costs were$26,400 and variable costs were 67 % of sales. (a) Your answer has been saved and sent for grading. See Gradebook for score details Determin...
##### Please show thorough work c. 2.91 x 10"N, same with the electric field d.2.91 x 10°N,...
please show thorough work c. 2.91 x 10"N, same with the electric field d.2.91 x 10°N, opposite to the electric field . 3. A solid spherical mass M-58.6 kg and radius 13.2 cm is concentric with a thin spherical shell M -86.4 kg and radius 32.3 cm as shown. A point mass m - 245 grams is at ...
##### T F Matrices with the same eigen values must be similar T F Similar matrices must...
T F Matrices with the same eigen values must be similar T F Similar matrices must have the same eigen vectors T F Similar matrices must have the same eigen values T F Similar matrices must have the same characteristic polynomial T F If A and B are similar, then they must be invertible T F If A and B...
##### This is the entire question. There is nothing else besides this image. A biology researcher wants...
This is the entire question. There is nothing else besides this image. A biology researcher wants to study the electrical properties of a few square micrometers of membrane. The thickness of the membrane is a few nanometers. He decides that he will mentally model this bit of the membrane as if it w...
##### Elasticity and fluids A circular cross section tube of diameter 1.2 m is carrying water (assume...
Elasticity and fluids A circular cross section tube of diameter 1.2 m is carrying water (assume the water is incompressible) from a dam to a town. The speed of the water in the tube is 0.500 ms-1. The diameter of the tube then narrows from 1.2m to 1.0m. Find the speed of the water in the narrow sect...
##### A baggage handler drops your 7.90 kg suitcase onto a conveyor belt running at 1.50 m/s...
A baggage handler drops your 7.90 kg suitcase onto a conveyor belt running at 1.50 m/s . The materials are such that μs = 0.570 and μk = 0.250. How far is your suitcase dragged before it is riding smoothly on the belt? How far is your suitcase dragged before it is riding smoothly on the belt?...
##### One mole of a dilute gas initially has a pressure equal to 1.00 atm, and a...
One mole of a dilute gas initially has a pressure equal to 1.00 atm, and a volume equal to 21.0 L and an internal energy of 3.19 kJ. As the gas is slowly heated, the plot of its state on a PV diagram moves in a straight line to the final state. The gas now has a pressure equal to 3.00 atm, and a vol...