Telah Dianugerahkan

University Student Database

Consider the data that are usually maintained by a typical university concerning students, courses, and enrollments. Students are admitted to the university, and they pursue a degree program in a particular department. The university 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.

A possible database design results in the following relational tables:

COURSES (Cno, Ctitle, Hours, DeptId)

DEPARTMENTS (DeptId, DeptName, College)

INSTRUCTORS (LastName, FirstName, DeptId, Office, Phone, Email)

SECTIONS (Term, LineNo, Cno, InstrLname, InstrFname, Room, Days, StartTime, EndTime, Capacity)

STUDENTS (Sid, LastName, FirstName, Class, Phone, Street, City, state, Zip, Degree, DeptId, hours, Gpa)

ENROLLMENTS (Sid, Term, LineNo, Grade)

Note: the primary key attributes are underlined. Foreign keys (Referential Integrity Constraints) are to be determined.

The COURSES table maintains the list of courses in the university catalog. Information about departments, instructors, and students is maintained in the DEPARTMENTS, INSTRUCTORS, and STUDENTS tables, respectively. 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. The SECTIONS table maintains the information about the schedule of classes for each term. The ENROLLMENT table keeps information about the enrollment of students in sections.

The following is an outline of a possible application program for the student database:

MAIN MENU

(1) Students functions

(2) Administrative functions

(3) Reporting functions

(4) Quit

STUDENT FUNCTIONS MENU

(1) Register for courses

(2) Add/Drop a course

(3) Request Transcript

(4) Compute GPA

(5) Quit

ADMINISTRATIVE FUNCTIONS MENU

(1) Create a new course/drop course

(2) Prepare term schedule (add sections)

(3) Add/drop instructors

(4) Alter term schedule (add/drop/update sections)

(5) Add/drop students

(6) Print the list of instructors and the number of courses each of them is teaching (for a term)

(7) Quit

REPORTING FUNCTIONS MENU

(1) Print schedule of classes (for a term)

(2) Print the catalog

(3) Print the honors list of students for a department (e.g. students whose GPA > 3.8)

(4) Quit

You have to implement the database system above. You can add additional functionality if you want and it will be appreciated. In particular you can add some stored procedures that are called from the application program.

IMPORTANT: BUSINESS LOGIC HAS TO BE IMPLEMENTED WITH ORACLE/PLSQL THRU FUNCTIONS ! NO OTHER PROGRAMMING LANGUAGE IS REQUIRED.

Kemahiran: Oracle

Lihat lebih lanjut: University Student Database, student database university, student table oracle, university registration system database, university registration database, university student database design, tables university database, university registration database system, tables student database university, university registration system database design, student results database oracle, database table design university students course, university student database oracle, tables students results university database, university database student course, oracle student department course database, database table university student, oracle student database, university database tables, university student enrollment database, university registration database tables, university student registration database, database tables university student, create university student database, university database department

Tentang Majikan:
( 15 ulasan ) Linden, United States

ID Projek: #1568394

2 pekerja bebas membida secara purata $150 untuk pekerjaan ini

dobreiiita

Hi, I am confident to handle this project, Thank You

$150 USD dalam 2 hari
(6 Ulasan)
3.3
droidco

Hi Check my PM.

$150 USD dalam sehari
(0 Ulasan)
0.0