Fermé

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.

Compétences : Oracle

Voir plus : 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

Concernant l'employeur :
( 0 commentaires ) Somalia

N° du projet : #12721501

24 freelance ont fait une offre moyenne de 157 $ pour ce travail

222 $ USD en 3 jours
(1 Commentaire)
2.8
jagdishbhatt38

A proposal has not yet been provided

250 $ USD en 12 jours
(3 Commentaires)
2.5
TahirBadar

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

222 $ USD en 7 jours
(1 Commentaire)
1.3
ivivek

Hello, This is in response to your job notification for the position of Java Professional for your project. I have been working as a Java developer for the last 5+ years with a software firm and mentione Plus

250 $ USD en 10 jours
(1 Commentaire)
1.0
45 $ USD en 3 jours
(0 Commentaires)
0.0
155 $ USD en 30 jours
(0 Commentaires)
0.0
KrullRed

A proposal has not yet been provided

35 $ USD en 3 jours
(0 Commentaires)
0.0
155 $ USD en 3 jours
(0 Commentaires)
0.0
ahfadl78

Ok i can do

155 $ USD en 3 jours
(0 Commentaires)
0.0
166 $ USD en 5 jours
(0 Commentaires)
0.0
pratik123

hi please contact me for further details. thanks

166 $ USD en 5 jours
(0 Commentaires)
0.0
nipunocp

A proposal has not yet been provided

155 $ USD en 3 jours
(0 Commentaires)
0.0
jssamarakoon

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

222 $ USD en 7 jours
(1 Commentaire)
0.0
codevin91

I am a java programmer and i have worked in Oracle database for last 3 years. So i have the knowledge and experience to do this work. I can do this DB design for you. The requirement is clear. I can start the work as s Plus

200 $ USD en 3 jours
(0 Commentaires)
0.0
prakash2813

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.

180 $ USD en 3 jours
(0 Commentaires)
0.0
s250030iva

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

60 $ USD en 2 jours
(0 Commentaires)
0.0
300 $ USD en 2 jours
(0 Commentaires)
0.0
hisabdallah

I have good and long experience in devleoping Oracle database applications using different Oracle development tools.

155 $ USD en 3 jours
(0 Commentaires)
0.0
kbilalsalim

I have over fifteen years of database design, development and administration experience using oracle database (8 to 11g) and different other tools. Started as a trainee developer to work with forms and reports and that Plus

200 $ USD en 30 jours
(0 Commentaires)
0.0
155 $ USD en 15 jours
(0 Commentaires)
0.0