IM2 DDL

Question 1: Write an SQL statement to create a new database called BookstoreDB.

Evaluate responses using AI:

OFF

Question 2: Write an SQL statement to create a table called Authors with fields: AuthorID (primary key), FirstName, LastName, and DateOfBirth.

Evaluate responses using AI:

OFF

Question 3: Write an SQL statement to create a table called Books with fields: BookID (primary key), Title, Genre, Price, and AuthorID (foreign key).

Evaluate responses using AI:

OFF

Question 4: Write an SQL statement to create a table called Customers with fields: CustomerID (primary key), FirstName, LastName, Email, Customer Code and PhoneNumber.

Evaluate responses using AI:

OFF

Question 5: Write an SQL statement to DELETE the BookstoreDB.

Evaluate responses using AI:

OFF

Question 6: Write an SQL statement to create a new database called LibraryDB.

Evaluate responses using AI:

OFF

Question 7: Write an SQL statement to create a table called Authors with fields: AuthorID (primary key), FirstName, LastName, and Biography.

Evaluate responses using AI:

OFF

Question 8: Write an SQL statement to create a table called Books with fields: BookID (primary key), Title, Genre, PublicationDate, and AuthorID (foreign key).

Evaluate responses using AI:

OFF

Question 9: Write an SQL statement to create a table called Borrowers with fields: BorrowerID (primary key), FirstName, LastName, Email, and PhoneNumber.

Evaluate responses using AI:

OFF

Question 10: Write an SQL statement to DELETE the LibraryDB.

Evaluate responses using AI:

OFF