Book (BookID, Price, Year, Author, Subject)BorrowLog (BID, BookID, CustomerID, DateTime)Customer (CustomerID, CustomerName, Address, City)Write the DDL script to create “smallLibrary” database with the given three tables. Please include the primary key and referential constraints for the foreign key.

Answered: Book (BookID, Price, Year, Author,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Book (BookID, Price, Year, Author, Subject)
BorrowLog (BID, BookID, CustomerID, DateTime)
Customer (CustomerID, CustomerName, Address, City)

Write the DDL script to create “smallLibrary” database with the given three tables. Please include the primary key and referential constraints for the foreign key.

Expert Solution

Basic

DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database.DDL is a set of SQL commands used to create, modify, and delete database structures but not data.