Database Design: Please populate the relations with three sample tuples for each

Question

Database Design:

Please populate the relations with three sample tuples for each relation. These sample tuples should conform to the constraints of the relational data model and the referential integrity constraints, as defined by you in (1b). Please state clearly which tuples are for which relation. Please answer this part in the form of four tables, one for each relation. For each table, please include the table name and column names besides the three tuples.

SALESPERSON (Salesperson-ID, Salesperson-name, Salesperson-phone) CAR (Car-VIN, Model, Manufacturer, Sticker-price) OPTIONALEQUIPMENT (Car-VIN, Option-name, Price) DEAL (Salesperson-ID, Car-VIN, Date-of-transaction, Final-price)

Explanation / Answer

SALESPERSON:----

1. Insert into SALESPERSON( 111,'JOHN',123456);

Insert into SALESPERSON( 112,'JAMES',234567);

Insert into SALESPERSON(113, 'DEBBY',345678);

CAR:---

2.Insert into CAR(1011,'VDI', 'SUZIKI', 300000);

Insert into CAR(1012,'LXI', 'SUZIKI', 400000);

Insert into CAR( 1013, 'ZXI', 'SUZIKI', 500000);

OPTIONAL EQUIPMENT:----

3. Insert into OPTIONAL_EQUIPMENT( 1011, 'LCD TV',35000);

Insert into OPTIONAL _EQUIPMENT(1011, 'SPEAKERS', 25000);

Insert into OPTIONAL _EQUIPMENT(1012, 'MP3 PLAYER', 15000);

DEAL:-----

4. Insert into DEAL(112,1012,'10-01-2017',350000);

Insert into DEAL(111,1011,'11-01-2017',450000);
Insert into DEAL(113,1013,'12-01-2017',500000);

The above are the insert statements as well as tables form also. NO CONSTRAINTS will be violated with these data.

If need any additional information please comment.

SALESPERSON _ID SALESPERSON _NAME SALESPERSON _PHONE 111 JOHN 123456 112 JAMES 234567 113 DEBBY 345678

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.