Question: 1. Give the business rules for the tables 2. Give relational schema for all the tables 3. Create Relational diagram for the database. 4.

1. Give the business rules for the tables 2. Give relational schema

1. Give the business rules for the tables 2. Give relational schema for all the tables 3. Create Relational diagram for the database. 4. Identify the TRUCK table's any two [2] candidate keys 5. For BASE table, identify any two [2] super keys Table name: TRUCK Primary key: TRUCK_NUM Foreign keys: BASE_CODE, TYPE_CODE TRUCK_NUM BASE CODE TYPE_CODE TRUCK_MILES TRUCK_BUY DATE TRUCK_SERIAL_NUM Database name: Ch03_TransCo 1001 501 32123.5 23-Sep-07 AA-322-12212-W11 76984.3 1002 1003 502 05-Feb-06 AC-342-22134-Q23 501 2 12346.6 11-Nov-06 AC-445-78656-Z99 1004 2894.3 06-Jan-07 WQ-112-23144-T34 1005 1006 1007 1008 1009 503 2 45673.1 01-Mar-06 FR-998-32245-W12 15-Jul-03 AD-456-00845-R45 193245.7 32012.3 44213.6 501 2 502 3 17-Oct-04 AA-341-96573-Z84 07-Aug-05 DR-559-22189-D33 12-Feb-08 DE-887-98456-E94 502 3 503 10932.9 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE CODE BASE CITY BASE STATE BASE AREA_CODE BASE PHONE BASE_MANAGER 123-4567 TN 615 Andrea D. Gallager 501 Murfreesboro 502 Lexington 503 Cape Girardeau MO 504 Dalton KY 568 234-5678 George H. Delarosa 456 345-6789 Maria J. Talindo GA 901 456-7890 Peter F. MCAvee Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE CODE TYPE DESCRIPTION 1 Single box, double-axde 2 Single box, single-axle 3 Tandem trailer, single-axle

Step by Step Solution

★★★★★

3.41 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Truck a Every Base code present in the Truck table must be present in the Base table b Every Type nu... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Computer Engineering Questions!

Create a relational database schema from the ERD your designed in question 42 showing all tables in 3NF Each table should include at least three fields Appropriate primary keys should be used Primary...

Identify the primary and foreign keys for the entity-relationship diagram created in Problem 14.

Create the relational diagram for the database shown in Figure.

Using ?VehicleFailureData? available on the course website, answer the following: Classify each variable as nominal, ordinal, interval or ratio. Identify qualitative and quantitative variables. How...

accounting project JA2503 I SEE THE LIGHT JA2503.xls, Jennifer, when you are ready to have your work graded you will upload this file to the same screen that the project was downloaded from:...

Can someone please guide me through the last question titled Exercise 2 going for 2 where you have to use the AND OR and ABS formulas I can't wrap my head around doing it. MIS 204 - Lab 3 This lab...

Background: As an owner or a manager of a business, in order to make decisions to either enhance the profitability or take action to reduce losses, one needs timely summary of important financial...

Create the ERD for this database using Crow s foot notation. Thank you to anyone reviewing it! 2. Given the following database: Table name: TRUCK Primary key: TRUCK_NUM Foreign keys: BASE_CODE,...

Smith Die Company manufactures cutting dies for the shoe industry. Each set of dies is custom designed to a customer's templates. During the first week of May, six orders were received from...

I need to figure out the cell formula for this question . What is the cell formula for the premium sections ? 1 Calculate the insurance premium values for Columns E and I. The formulas are based on a...

Drsign. heur traffie flows at 4 leys-3phase in the table be low : The vntersection are given Intergreen peried of 5 sees. and the start ing de lay of 29 Secs. per green intervals are used wth fived...

Do cultural variations interact to influence education?

According to Joel Klippert, the number one thing any entrepreneur has to have is: Question 1 options: a pit - bull mentality a differentiated product or service multiple investors a product or...

For each of the following activities, identify whether process costing or job order costing should be used. Also indicate how manufacturing overhead should be applied to the product - whether...

Masha Potata, a restaurant owner, replaced an industrial size mixer less than a year ago. Today, Madame Mix-a-lot Manufacturing announced the availability of a new mixer that mashes in half the time...

Gillian has entered the agreement with Geoffrey described above. She estimates that the costs of the delivery services she has promised to Geoffrey (petrol, insurance, wear and tear, etc) amount to...

what should you watch out for when forming heat treated and cold worked alloys?

Typically, a patient staying in a hospital receives medications that have been ordered by a particular doctor. Because the patient often receives several medications per day, there is a 1:M...

Develop a deployment diagram for the network mentioned in the previous problem. The new Benefits for Employees, Spouses, and Dependents (BESD) system will be used primarily by the human resource...

In Chapter 4, you saw the creation of the Tiny College database design. That design reflected such business rules as a professor may advise many students and a professor may chair one department....

Use the following business rules to create a Crows Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. a. A department employs many employees, but each employee is employed...

Refer to the entity relationship diagram in problem 4. Modify the diagram to deal with payments of merchandise purchased. Explain the business rules represented by the cardinalities in thediagram....

The business rules that constitute the purchases system for the Safe Buy Grocery Stores chain are similar at all the store locations. The purchase manager at each location is responsible for...