Ditutup

University Student Oracle Database

UNIVERSITY PROJECT FOR ORACLE ORACLE/PLSQL.

Full description is in attachment. Most of the project is either done ( Phase1&2 is in attachment or working on). Need help only on STUDENT FUNCTIONS MENU from Phase 3.

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

A 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)

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 application program for the student database:

STUDENT FUNCTIONS MENU

(1) Register for courses

(2) Add/Drop a course

(3) Request Transcript

(4) Compute GPA

(5) Quit

Kemahiran: Oracle, SQL

Lihat lebih lanjut: student database project oracle, college enrollment database design oracle, oracle student database, oracle database university project, student database project, university database project, project student database oracle, oracle database project university student, working for oracle, sql to oracle, sql programming language, sql programming course, sql database business, programming logic and design, programming language list, programming degree, programming courses, programming college, program for design room, plsql or, plsql &, oracle programming language, oracle plsql for, oracle functions sql, logic programming language

Tentang Majikan:
( 15 ulasan ) Linden, United States

ID Projek: #1568657

10 freelancers are bidding on average $41 for this job

saqibilyas

please check PMB...

$50 USD dalam 2 hari
(1 Ulasan)
1.3
abbasitech

Hi there, I can do it for you. Check out my reviews about ORACLE RDBMS from employers. Can deliver you within 2 days, 1 extra day is for [url removed, login to view]'s it. Straight and Forward. Thanks and Regards, ABBASITECH (IT S Lagi

$50 USD dalam 3 hari
(2 Ulasan)
1.0
pkdn00

Over 20 years experience in Oracle DBMS v. 6-10g, PL/SQL, SQL*Plus applications. The database creation will be done thru TOAD and the applications and menus in SQL*Plus. Time to complete 2 days. Application det Lagi

$40 USD dalam 2 hari
(0 Ulasan)
0.0
musonnet

I have been working on the Oracle for the similar projects. This is not a big deal.

$45 USD dalam 14 hari
(0 Ulasan)
0.0
milindshah1986

Hi, I am an Microsoft® Certified Technology Specialist MCTS. Microsoft Certification ID: 8547963 I can finish this work in very minimum time. Please consider my bid. Thanks and Regards, Milind Shah

$30 USD dalam 3 hari
(0 Ulasan)
0.0
debashismallick

I am Oracle Certified Developer can complete the project . I have full confident on it

$35 USD dalam 2 hari
(0 Ulasan)
0.0
edwardwei

Dear Sir/Mandamn, I'd like to have a try. Please kindly consider my qualifications in PM, thanks. Best Regards, Edward

$30 USD dalam 3 hari
(0 Ulasan)
0.0
lynwode

Hi, 15 Years commercial PL/SQL Development Experience, please see PMB for more details.

$50 USD dalam 2 hari
(0 Ulasan)
0.0
mevebe

I can do this.

$30 USD dalam 3 hari
(0 Ulasan)
0.0
rahulag2012

I'm profession employee in oracle plsql and working also on forms and reports.

$50 USD dalam 7 hari
(0 Ulasan)
0.0