Question

Write the MySQL command to create the table "ALBUM" as per the following structure.
Table: ALBUM
Column Name
Constraints
Albumid
Name
SingerName
Price
Data Type (Size)
Char (5)
Char (3)
Varchar (40)
Decimal (8.2)
Primary Key
Not Null
Define Primary key,Candidate key and Alternate Key,
Identify the following SQL commands as DDL or DML commands.
CREATE, SELECT, UPDATE, ALTER, INSERT, DROP​

Answer 1

Answer:

Explanation:

Write the MySQL command to create the table "ALBUM" as per the following structure.

Table: ALBUM

Column Name

Constraints

Albumid

Name

SingerName

Price

Data Type (Size)

Char (5)

Char (3)

Varchar (40)

Decimal (8.2)

Primary Key

Not Null

Define Primary key,Candidate key and Alternate Key,

Identify the following SQL commands as DDL or DML commands.

CREATE, SELECT, UPDATE, ALTER, INSERT, P​