Suljettu

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.

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: barry university transcript request form, university student enrollment database, database tables university student, student university registration, oracle database project university student, database tables university, university student oracle database outline, database lecturers university, database students university, database table university student, java student university institute management software, java exam student university, write program keeps track student information university, name student university luzon, transcript request osmania university

About the Employer:
( 0 reviews ) India

Projektin tunnus: #13162288

24 freelanceria on tarjonnut keskimäärin 135 € tähän työhön

utkarshkatiyar19

A proposal has not yet been provided

200 € EUR 3 päivässä
(7 arvostelua)
3.3
bommakanti321

Hi This is Madhurima. I am a Data Entry Operator, Document Writer, Blog Posting, proofreading and Article Writer. Work is my passion and completing the given work within the time is my hobby. As a resilient woman, I c Lisää

155 € EUR 3 päivässä
(5 arvostelua)
1.8
menon06

A proposal has not yet been provided

111 € EUR 9 päivässä
(3 arvostelua)
1.7
Avirup99

I understand your requirements for the job and I think I will be able to do it efficiently as I have previously worked with Oracle database and plsql

100 € EUR 5 päivässä
(2 arvostelua)
1.0
HaykDag

A proposal has not yet been provided

133 € EUR 1 päivässä
(1 arvostelu)
0.5
rajibspi7

I know what do you want and i have more skill about your project. So contact with me about your project done in time with your budget.

155 € EUR 3 päivässä
(1 arvostelu)
0.5
soumyaraypro

I have been working on this platform since 4 years and will possibly deliver you the job with best results and in given time.

78 € EUR 2 päivässä
(0 arvostelua)
0.0
ravinapatil

A proposal has not yet been provided

155 € EUR 3 päivässä
(0 arvostelua)
0.0
kleinewaage

A proposal has not yet been provided

77 € EUR 2 päivässä
(0 arvostelua)
0.0
himanshudhiman19

A proposal has not yet been provided

155 € EUR 3 päivässä
(0 arvostelua)
0.0
gogothesaint

A proposal has not yet been provided

100 € EUR 3 päivässä
(0 arvostelua)
0.0
OliviaRotich13

A proposal has not yet been provided

155 € EUR 3 päivässä
(0 arvostelua)
0.0
sabreenis35

A proposal has not yet been provided

34 € EUR 15 päivässä
(0 arvostelua)
0.0
155 € EUR 3 päivässä
(0 arvostelua)
0.0
111 € EUR 3 päivässä
(0 arvostelua)
0.0
l0c9st

Please, help me to start working on [url removed, login to view] - i'll make you work with pleasure referfrfrerfgrg

222 € EUR 5 päivässä
(0 arvostelua)
0.0
ranamon7086

A proposal has not yet been provided

144 € EUR 3 päivässä
(0 arvostelua)
0.0
155 € EUR 3 päivässä
(0 arvostelua)
0.0
Nikki951

I have two years experience doing data entry for competition entries from multiple expos and shows for a medium company.

77 € EUR 3 päivässä
(0 arvostelua)
0.0
120 € EUR 3 päivässä
(0 arvostelua)
0.0