Business Rules for Database (CSC72001)

Running head: DATABASE SYSTEMS (CSC72001)
Database Systems (CSC72001)
Name of the Student
Name of the University
Authors note

DATABASE SYSTEMS (CSC72001)
1
B1
The business rules for the database
Each student entry will have a unique studentID,
An individua student can enroll to multiple units that are not overlapping with each
other.
Every workshop_enrollment has a student ID.
Any entry in the student assessment table must have the final grades for the unit.
None of the Teachers can be assigned to the workshops that have the overlapping time
schedule.
Assessments should not have submission date after the due date (Student having
extensions can have different scenario)
Assumptions made for this project
For this project, It is assumed that the personnel who will handle the data entry will be
correct one for different fields for the students.
As the tables are normalized thus it is assumed that the database schema will use the
lesser amount of storage.
The Users of the database will not be able to delete any record if there are any foreign
references and they have to be careful in deleting or modifying any record.

DATABASE SYSTEMS (CSC72001)
2
The database is developed in order to maintain the consistency of the data.
Changes/modifications knowingly/unknowingly may will lead to inconsistency of the developed
database.
End users of the developed database ae assumed to be able to use the operations in the
database with basic computer knowledge.
Naming Conventions
For the naming of the column name the camelCase naming convention is used. In this
naming conventions each word inside the compound word is made capital. In this convention,
except the first word the initial of the next word is capitalized. In Software /database
development the camelCase is used for writing source code. The camelCase naming convention
is very helpful in developing database or application using programming as element/variable
names does not contain spaces. In this way this convention in the database the column names are
more human readable.
Datatypes selected
Following are the selected datatypes for the tables;
For the names of the students, teachers and descriptionsVARCHAR datatypes are selected. For
the numeric data the INTEGER data type is selected and finally for the date related columns the
DATE datatype is selected.
StudentNumber int