1. Consider the Premier Products database and come up with an additional table t

Question

1. Consider the Premier Products database and come up with an additional table that could be added to the database. Specify the new table's NAME, its primary key and other attributes. Provide three records or rows of sample data for this new table.

2. Consider an additional attribute that could be included in the CUSTOMER table of the Premier Products database. Provide sample data for one row.

3. Consider the Henry Books database and come up with an additional table that could be added to the database. Specify the new table's NAME, its primary key and other attributes. Provide three records or rows of sample data for this new table.

4. Consider an additional attribute that could be included in the PUBLISHER table of the Henry Books database. Provide sample data for one row.

5. Consider the Alexamara Marina database and come up with an additional table that could be added to the database. Specify the new table's NAME, its primary key and other attributes. Provide three records or rows of sample data for this new table.

6. Consider an additional attribute that could be included in the MARINA table of the Alexamara Marina database. Describe the attribute's data type and provide sample data for one row.

Explanation / Answer

Part (PartNum, Description, OnHand, Class, Warehouse, Price)

CREATE TABLE CUSTOMERS(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   AGE INT              NOT NULL,
   ADDRESS CHAR (25) ,
   SALARY   DECIMAL (18, 2),      
   PRIMARY KEY (ID)
);


BRANCH

BRANCH_NUM BRANCH_NAME BRANCH_LOCATION NUM_EMPLOYEES

1 Henry Downtown 16 Riverview 10

2 Henry On The Hill 1289 Bedford 6

3 Henry Brentwood Brentwood Mall 15

4 Henry Eastshore Eastshore Mall 9


PUBLISHER

PUBLISHER_CODE CITY

AH Sauk City WI

AP New York

BA Boulder CO

BP Boston

BY New York


Marina Group Database
(Case,Owner ,Sample data ,about marina ,slips ServiceCategory,service categories ,Sample marina data)

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

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