This document provides an overview of a database system for student enrollment. It covers the conceptual design, logical design, and implementation of the system. The document includes information on functional dependencies, relational schema, and SQL queries.
Contribute Materials
Your contribution can guide someone’s learning journey. Share your
documents today.
Running head: DATABASE SYSTEM Database System Name of the Student: Name of the University: Author Note
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
1 DATABASE SYSTEM Phase 0: Project Intent The project that is being discussed in the project is a student enrollment project. The system would be generally used in the schools for the students’ enrollment. The system would be offering the students a number of courses and hence the students would be enrolled in in the courses under a particular tutor whose records are stored in the system. The enrollmentclerkwouldgenerallyhandlethesystem.However,theinstancesofthe enrollment clerk has not been included in this report. However the clerk would be performing all the functions. This system would also act effectively in reducing the time consumptions of process in the organization and provide some better data maintenances options for the organization. The report contains the description of the database to be used in the system. The ER Diagram, the logical design and conceptual designs of the database has been included in the report. Some additional illustrations have also been described with the help of queries in the report.
7 DATABASE SYSTEM STORAGE(INITIAL65536NEXT1048576MINEXTENTS1MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "SYSTEM" ; INSERT INTO enrollment VALUES (1,1,1,4); INSERT INTO enrollment VALUES (2,2,1,5); INSERT INTO enrollment VALUES (3,4,2,5); INSERT INTO enrollment VALUES (4,3,2,4); INSERT INTO enrollment VALUES (5,2,3,3); INSERT INTO enrollment VALUES (6,5,3,2); INSERT INTO enrollment VALUES (7,1,4,3); INSERT INTO enrollment VALUES (8,5,4,2); INSERT INTO enrollment VALUES (9,3,5,1); INSERT INTO enrollment VALUES (10,2,5,1);
8 DATABASE SYSTEM SQL Queries Query 1: Course taught by Harris SELECT tutors.tutorname, courses.coursename from tutors INNER JOIN enrollment ON enrollment.tutorid = tutors.tutorid INNER JOIN courses ON enrollment.courseid = courses.courseid WHERE tutors.tutorname = 'Harris';
9 DATABASE SYSTEM Query 2: Course taught by James SELECT tutors.tutorname, courses.coursename from tutors INNER JOIN enrollment ON enrollment.tutorid = tutors.tutorid INNER JOIN courses ON enrollment.courseid = courses.courseid WHERE tutors.tutorname = 'James';
Paraphrase This Document
Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser
10 DATABASE SYSTEM Query 3: Course taught by Kelly SELECT tutors.tutorname, courses.coursename from tutors INNER JOIN enrollment ON enrollment.tutorid = tutors.tutorid INNER JOIN courses ON enrollment.courseid = courses.courseid WHERE tutors.tutorname = 'Kelly';
11 DATABASE SYSTEM Query 4: Course taught by Staurt SELECT tutors.tutorname, courses.coursename from tutors INNER JOIN enrollment ON enrollment.tutorid = tutors.tutorid INNER JOIN courses ON enrollment.courseid = courses.courseid WHERE tutors.tutorname = 'Stuart';
12 DATABASE SYSTEM Query 5: Course taught by David SELECT tutors.tutorname, courses.coursename from tutors INNER JOIN enrollment ON enrollment.tutorid = tutors.tutorid INNER JOIN courses ON enrollment.courseid = courses.courseid WHERE tutors.tutorname = 'David';
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.
16 DATABASE SYSTEM Query 9: Average Course Fee SELECT AVG(coursefee) FROM courses;
17 DATABASE SYSTEM Query 10: Minimum Course Fee SELECT MIN(coursefee) FROM courses;
18 DATABASE SYSTEM Phase 4: Advanced SQL Aspects For the security in the database, system the least privileges are to be provides to the users. Only the necessary privileges are to be granted to the users. The restriction for CREATEANYJOB,BECOMEUSER,EXP_FULL_DATABASE,and IMP_FULL_DATABASE privileges is to be done in the database. For additional security, the library privileges are to be granted only to the trusted users for the system. The administrative schema such as SYS and SYSDBS are not to be granted access for the non-administrative users.
Secure Best Marks with AI Grader
Need help grading? Try our AI Grader for instant feedback on your assignments.