Scribd
Upload
60 views1 page

Homework 4 PDF

The document provides instructions for a homework assignment to create and modify a university database. It instructs the student to create a university database with a student table containing fields like name, address, and marks. It then asks the student to use ALTER commands to add a date of birth column and modify an existing column's data type or size. Finally, it asks the student to provide an example of implementing each type of constraint: primary key, foreign key, not null, and check.

Uploaded by

Mujeeb Rahman Dost
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
60 views1 page

Homework 4 PDF

The document provides instructions for a homework assignment to create and modify a university database. It instructs the student to create a university database with a student table containing fields like name, address, and marks. It then asks the student to use ALTER commands to add a date of birth column and modify an existing column's data type or size. Finally, it asks the student to provide an example of implementing each type of constraint: primary key, foreign key, not null, and check.

Uploaded by

Mujeeb Rahman Dost
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

DATABASE MANAGEMENT

HOMWORK -2

1- CREATE A UNIVERSITY DATABASE


2- CREATE STUDENT TABLE IN UNIVESITY DATABASE HAVING FOLLOWING
COLUMNS
a. SID
b. NAME
c. LNAME
d. ADDRESS
e. EMAIL
f. PHONE
g. COUNTRY
h. SUBJECT
i. MARK
3- USING ALTER COMMANDS ADD ONE MORE COLUMN IN NAME OF DOB
4- USING ALTER COMMANDS SHOW HOW TO MODIFY A COLUMN AND CHANGE
THE DATATYPE AND SIZE OF THE FIELDS
5- MAKE ONE EXMAPLE FOR EACH CONSTRAINTS
a. PRIMARY KEY
b. FOREIGN KEY
c. NOT NULL
d. CHECK

You might also like