1 answer

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.


Answers

DATABASE DESIGN:

Branch Branch_ID: bigint (NN) Name: text (NN) Telephone: bigint Location: text Branch_ID FK_Branch_DEPT Department Name: text

.

Similar Solved Questions

1 answer
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...
1 answer
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...
1 answer
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)...
1 answer
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...
1 answer
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....
1 answer
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...
1 answer
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...
1 answer
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 ...
1 answer
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...
1 answer
Millennial Works, Inc. issued $5,000,000 of 8%, five-year bonds on April 30, 2019. Interest on the...
Millennial Works, Inc. issued $5,000,000 of 8%, five-year bonds on April 30, 2019. Interest on the bonds is due on October 31, and April 30 beginning on October 31. 2019: Required: 1. Prepare the journal entries necessary to record the 2019 activity if the bonds were sold to yield 8% 2. Show what wo...
1 answer
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...
1 answer
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...
1 answer
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?...
1 answer
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...
1 answer
Tom and Jessica are best friends, but they couldn’t be more different when it comes to...
Tom and Jessica are best friends, but they couldn’t be more different when it comes to their diets. Tom spends a lot of time in the gym surrounded by body builders and has adopted a very protein-heavy diet, complemented by small amounts of vegetables and a vitamin/mineral supplement, which he ...
1 answer
1. You will develop a Python program to manage information about baseball players. The program will...
1. You will develop a Python program to manage information about baseball players. The program will maintain the following information for each player in the data set: player’s name (string) team identifier (string) games played (integer) at bats (integer) runs scored (integer) hits (integer) ...
1 answer
Please help me with all parts ill leave you a good review and a thubms up...
please help me with all parts ill leave you a good review and a thubms up Check my work Amber Mining and Milling, Inc., contracted with Truax Corporation to have constructed a custom-made lathe. The machine was completed and ready for use on January 1, 2021. Amber paid for the lathe by issuing a $5...
1 answer
Please read the following prompt carefully: "About 48% of all births result in a girl. Suppose...
Please read the following prompt carefully: "About 48% of all births result in a girl. Suppose a couple is planning to have three children." Determine the following values by rounding to the nearest indicated decimal place. Please type your solution in the text entry boxes provided. e. What ...