CSC 443 Data Base Management Systems

Dr. R. M. Siegfried

Assignment 3 - Maintaining a Database

Due Monday, September 30, 2013

We are going to make certain changes to the database that we created in Assignment #2.

The changes are:

1. Add an additional ADVISOR :

   Advisor ID	Last Name	First Name
   1222	McCartney	Paul



2. Add 3 sections to the SECTIONS table:

   Section ID	Course IS	Term	Section Year	Instructor
   11510103	CS101	Fall	2012	Pepper
   11510104	CS101	Fall	2012	Smith
   30110102	HIS101	Fall	2012	Murphy



3. Delete Craig Ash's record from the ADVISOR table.


4. Use a Filter by Selection to filter out all but 4 credit courses


5. Use a Common Filter on REGISTER to display only course registrations with grades of A- or A.


6. Use the Look-up wizrd to add DEPARTMENT an additional column to the ADVISOR table. Have it entries restricted to the Major codes 101, 152 , 225 , 341 , and 635 .
7. Add a Validation Rule that CREDITS r in the STUDENT must be between 0 and 130 . 130.

[Back to the Assignment Page]