Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

part b please (B) Construct an ERD for a used car shop. A salesman will buy and sell cars. A client can either buy or

part b please

image text in transcribed

(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: o VARCHAR(SIZE [BYTE | CHAR]) - Variable-length character data, with maximum length size bytes or characters o CHAR(SIZE [BYTE | CHAR]) - Fixed-length character data of length size bytes or o NUMBER(p, s) - Variable-length numeric data with precision p and/or scales o INTEGER gets created as NUMBER(38) ?DATE-Fixed-lengthatateasNUMBER(38) o DATE - Fixed-length date and time data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Flash XML Applications Use AS2 And AS3 To Create Photo Galleries Menus And Databases

Authors: Joachim Schnier

1st Edition

0240809173, 978-0240809175

More Books

Students also viewed these Databases questions