Question: (B) Construct an ERD for a used car shop. A salesman will buy and sell cars. A client can either buy or sell their

(B) Construct an ERD for a used car shop. A salesman will buy and sell cars. A client can either buy or sell their car. Please assign only 3 attributes per entity/relationship. Identify the primary keys. (20 points) Additional Information: You may use any of the following data types: VARCHAR(SIZE [BYTE | CHAR]) - Variable-length character data, with maximum length size bytes or characters CHAR(SIZE [BYTE | CHAR]) - Fixed-length character data of length size bytes or characters NUMBER(p, s) - Variable-length numeric data with precision p and/or scale s INTEGER - gets created as NUMBER(38) DATE - Fixed-length date and time data
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
