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
Written for
- Institution
- Biochem
- Course
- Biochem
Document information
- Uploaded on
- July 29, 2023
- Number of pages
- 3
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
cs 561 assignment 7
-
assignment 7 stevens i