Course list http://www.c-jump.com/bcc/
Write down 10 or more rules about useful relationships between the entities in the college database. For example,
Students may not enroll in courses if such enrollment yields a scheduling conflict.
Each Instructor must have a DepartmentID assigned.
Enrollment record must include a valid SectionID and StudentID.
A Section can be created with a blank time slot. The time slot can be specified later.
This exercise should help as soon as we begin implementing the actual database in MS Access.
Feel free to elaborate on the meanings of the rules. Think about
The purpose of the rule or relationship
Its importance ranking. In simple terms, you can indicate whether it is Important, Essential, or Optional, Maybe, etc. Expand the ranking scale as you see fit.
Similar to algorithm examples shown at the end of the Database Design handout, write an algorithm to print names of instructors who didn't teach any courses in a given semester.
List additional entitities or suggest a change to an existing entity described in the Database Design handout.
Write a brief paragraph explaining your idea and specify the key attributes (table columns) as usual:
EntityName
---------
*ID
Attribute1
Attribute2
...
AttributeN
Submit a file with your answers by attaching to the email to your instructor:
Igor Kholodov
Igor.Kholodov@bristolcc.edu
Suggested email subject line:
CIT122 Homework 3 Lastname, Firstname
where Lastname, Firstname is your last and first name.
Remember to include your last name (mandatory!) and first name (or at least the first name initial) in the document, too.