Think about the data that are usually maintained by a typical college concerning students,
courses and enrollments.
Students are admitted to the college, and they pursue a degree program in a particular department.
The college catalog consists of courses that are offered every term.
Students choose courses to take and enroll in them during registration.
Instructors are assigned courses to teach, and they in turn assign grades.
to create the tables. Primary keys, secondary keys, foreign
keys, referential triggered actions, and NOT NULL constraints should be correctly
Notice that some of the columns in the **STUDENTS** table are computed columns (gpa,
hours) ??" i.e., their values are determined by other values in other tables. You can
choose not to include these attributes into the schema and to implement them as
separate functions in the STUDENT FUNCTIONS MENU (see below), or to include
them in the schema and to use triggers to update their value every time the attributes
referenced in the trigger are updated.
**_(2)_** Use SQL assertions or CHECK clauses in the definition of the tables to enforce the
(a) Students can register for at most 15 credits each semester.
(b) Instructors can teach at most 2 courses and at most 4 sections each semester.
(c) Students can register for course offered by at most two different departments each
(d) A student cannot register twice for the same course in a semester.
**_(3)_** Write SQL statements to populate your tables. Make sure you have ample sample
data in your tables so that you can sufficiently perform and illustrate all required tasks.
**_(4)_** Implement a database system application. You can use any language as a host-language for the application. The system must include the basic functionality described below. You are not required to implement a fancy GUI.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).
5) Description of implementation, problems faced
6 )Users guide
7) The SQL commands that create the tables
8) The SQL commands that populate the tables
9) The source code.
"Windows XP", "in all 3.0+ versions of Internet Explorer and Netscape", "Linux"