Question

create a table name production with following information

Column Name data type
P_Id. Integer
Name. Char(20)
Type. Char(10)
Manufacturer. Char(20)
Address. varchar(10)

1.) identify the primary key of the table production . also give reason.

2.) distinguish between degree and cardinality.

PLEASE DON'T SCAM​

Answer 1

Answer:

CREATE TABLE PRODUCTION (

P_Id int,

Name char(20),

Type char(10),

Manufacturer char(20),

Address varchar (10)

);

1.) P_Id is the primary key in this case, Because this column of data, will not contain any null value or the data will be unique in the table PRODUCTION.

2.) Degree :- No. of Columns or Attributes in a relation (table).

Cardinality :- No. of Rows or Tuples in a relation (table).