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:
(1) Students functions
(2) Administrative functions
(3) Reporting functions
STUDENT FUNCTIONS MENU
(1) Register for courses
(2) Add/Drop a course
(3) Request Transcript
(4) Compute GPA
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)
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)
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.
24 freelance font une offre moyenne de $157 pour ce travail
Hello, I can build you student management system in oracle and can write all the logic s in pl saq. please let me know if you want me to proceed. Thanks Regards, Tahir Badar
Hi, I am a Oracle developer,DBA over 10 years of experience in Finance and Telecommunications domains. Would like to do this project, please send me more details. I am available 1800 -2300 Hrs daily Thank you
Hi there, I am desktop and web developer. I have strong knowledge in database development. This is an easy job for me. Message me, we can discuss further details over chat.
Dear , Around morethan 12+ years experience in the field. I can able to finish and deliver on time Will provide your desired output and with documents. Consider my request Thanks