Assignment#2.docx - Introduction to Database Concepts...

Introduction to Database Concepts COMP122
Assignment 2 – SQL Commands
Due Date: Midnight of June 17, 2022 (Friday)
Purpose: The purpose of this assignment is to help you:
 Become familiar with creating table, populating data
 Distinguish column level constraint and table level constraint
Instructions : Be sure to read the following general instructions carefully:
This assignment should be completed individually by all the students. Submit your
solution through the dropbox, Your submission should include sql command and the
screenshot of command execution result, the submission must be named according to the
following rule: studentID(yourlastname)_Assignment#number.doc e.g.,
300123456( smith)_Assignemt#2 .doc.
Questions [12 marks]
Create 3 tables based on the ER model shown below. Include necessary constraints in the
CREATE TABLE statements. Name all constraints except NOT NULL properly