Question: 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

Create the ERD for this database using Crows foot notation.

Create the ERD for this database using Crows foot notation. Thank you Thank you to anyone reviewing it!

2. Given the following database: 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 1001 1002 1003 1004 1005 1006 1007 1008 1009 Database name: Ch03TransCo 501 32123.5 76984.3 12346.6 2894.3 45673.1 193245.7 32012.3 442136 10932.9 23-Sep-07 AA-322-12212-W11 05-Feb-06 AC-342-22134-023 11-Nov-06 AC-445-78656-Z99 06-Jan-07Q-112-23144-T34 01-Mar-06 FR-998-32245-12 15-Jul-03 AD-456-00845-R45 17-Oct-04 AA-341-96573-Z84 07-Aug-05 DR-559-22189-D33 12-Feb-08 DE-887-98456-E94 501 2 503 503 2 Table name: BASE Primary key: BASE_CODE Foreign key: none BASE CODE BASE_CITY BASE STATE BASE_AREA CODE BASE PHONE BASE MANAGER 501 Murfreesboro 502 Lexington 503 Cape Girardeau 504 Dalton TN KY MO 615 568 456 123-4567 234-5678 345-6789 456-7890 Andrea D. Gallager George H. Delarosa Maria J. Talindo Peter F.McAvee Table name: TYPE Primary key: TYPE_CODE Foreign key: none TYPE CODE TYPE_DESCRIPTION 1 Single box, double-axle 2 Single box, single-axle 3 Tandem trailer, single-axle

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Databases Questions!

JetGreen Airline Database JetGreen Airlines is a new small airline company for domestic flights. The company needs to build a database system to store information about its flights, aircrafts,...

DATABASE Question 1: Create one database and then write SQL statements to create, in this database, all tables derived from the ERD given in the following picture with appropriate attributes, primary...

Phase 1: Design Conceptual Design: Create an (Enhanced) Entity-Relationship Diagram. o Include all entities, relationships, and attributes that will meet the business rules and satisfy the forms and...

There is also a part E that has gotten cut off E. Create the ERD for this database using Crow s foot notation. Thank you to anyone reviewing it! Suppose that you have the ERM shown below: During some...

Create a logical ERD for each of the problems on the following pages using the crows foot notation. Be sure that each entity has the entity name at the top of the box, the primary key attribute or...

Objectives: Show evidence that you have learned the following course competencies by designing, implementing, and querying the database as described in this document Create a database ERD while...

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

Create Entity Relational Diagram* Instructions An Entity Relationship diagram is one of the most important diagrams for any major piece of software. In fact, given a sufficiently detailed ERD, a...

Can someone please help/advice/any idea my term project! The term project for this course will be to design and construct a database that uses appropriate Transact SQL procedures and functions. The...

Determine the average power delivered to the resistor in figure a, if the current waveform is shown in figure b. a. 18.78 W b. 8.64 W c. 2.82 W d. 10.91W i(t) (A)+ i(t) 2 3 t(s) -2 (a) (b) 2.

Hammond Inc. has analyzed the setup time on its computer-controlled lathe. The setup requires changing the type of fixture that holds a part. The average setup time has been 135 minutes, consisting...

please find Weight of debt in the firm's capital structure Weight of preferred stock in the firm's capital structure Weight of common stock in the firm's capital structure After - tax cost of debt...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

LO6 Outline approaches to employee discipline and termination of employment.

1. There is heightened awareness and concern in organizations about data security and privacy. Recent breaches of databases in many large retailers and government agencies have increased peoples...

1. Determine the organizations readiness for ADR. Is ADR consistent with the organizations culture and other HR processes? There needs to be a good match between culture and process for ADR to work.