University Database

**College Database**

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

following constraints:

(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.

## Deliverables

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.

## Platform

"Windows XP", "in all 3.0+ versions of Internet Explorer and Netscape", "Linux"

Habilidades: Reescrever Artigos, Redação Publicitária, Processamento de Dados, Engenharia, Java, MySQL, PHP, Research Writing, Arquitetura de software, Teste de Software, SQL

Veja mais: system to teach, schema update, teach java, student registration system, student database, sql commands, semester, Instructors, gpa, database system, college database, c university, university database department, registration system program java, java student registration system database, database program java, java gui sample code, schema populate, linux database gui, time triggered, update sql form application, university database tables, identified problems, can create university database, database system sql

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #3041655

Concedido a:


See private message.

$31.45 USD em 4 dias
(33 Comentários)

9 freelancers estão ofertando em média $37 para esse trabalho


See private message.

$42.5 USD in 4 dias
(27 Comentários)

See private message.

$42.5 USD in 4 dias
(19 Comentários)

See private message.

$51 USD in 4 dias
(17 Comentários)

See private message.

$25.5 USD in 4 dias
(22 Comentários)

See private message.

$25.5 USD in 4 dias
(30 Comentários)

See private message.

$51 USD in 4 dias
(0 Comentários)

See private message.

$25.5 USD in 4 dias
(0 Comentários)

See private message.

$42.5 USD in 4 dias
(0 Comentários)