CS 561 Assignment 7
CS 561 Assignment 7 1. Write appropriate SQL DDL statements for declaring the LIBRARY relational database schema. Solution: Data Definition Language (DDL) statements are commands used for creating, modifying and deleting database objects such as tables, indexes and users. DDL statements include CREATE, ALTER and Drop commands. For the given example i.e. Library database schema the following SQL DDL statements can be declared: a. Create table BOOK (Book_id varchar (12), Title varchar (50), Publisher_name varchar (30), primary key (Book_id), foreign key (Publisher_Name) references PUBLISHER
Información del documento
- Subido en
- 29 de julio de 2023
- Número de páginas
- 3
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas