Weekly_Report - Linda Chhay Database Theory and...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Linda Chhay Database Theory and Applications Project Description:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The objective of this project is to go through the entire process required in order to make a reliable and useful database. We get to extract business rules from an example model scenario in a college that could very well happen in real life. An ERD is used to model the cardinalities, connectivities, and relationships of the entities in the scenario given. Lastly we get to use structured query language to implement the database and manipulate the data as we will likely do in a real world environment. After doing the project a more thorough understanding of the processes in making a database is understood because we get valuable hands on experience with a popular enterprise relational database management system called Oracle. Business Rules: Department accepts one or more students Each student has only one department Department offers one or more courses Each course is offered by one and only one department Grade reports contains one or more sections Each section shows in one or more grade reports Student gets one or more grade reports Grade reports are created for one and only one student Course generates one or more section A section belongs to one course Active Verbs and Entities
Background image of page 2
DEPARTMENT HAS STUDENT DEPARTMENT OFFERS COURSE GRADE REPORT CONTAINS SECTION STUDENT GENERATES GRADE_REPORT COURSE GENERATES SECTION Relationships, Cardinality, PK, and FK Entity 1 Cardinality Relationship Connectivities Entity 2 Cardinality DEPARTMENT (1,N) enrolls 1:M STUDENT (1,1) DEPARTMENT (1,N) offers 1:M COURSE (1,1) SECTION (1,N) is found in 1:M ENROLL (1,1) STUDENT (1,N) gets 1:M GRADE_REPORT (1,1) COURSE (1,N) generates 1:M SECTION (1,1) GRADE REPORT (1,N) is found in 1:M ENROLL (1,1) Entity Primary Key Foreign Key STUDENT STU_NUM DEPT_CODE COURSE C_CODE DEPT_CODE GRADE_REPORT REPORT_NUM STU_NUM SECTION SECT_NUM C_CODE DEPARTMENT DEPT_CODE NONE ENROLL REPORT_NUM, SECT_NUM REPORT_NUM, SECT_NUM Crow’s Foot ERD:
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
DEPARTMENT PK DEPT_CODE STUDENT PK STU_NUM FK1 DEPT_CODE GRADE_REPORT PK REPORT_NUM FK1 STU_NUM COURSE PK C_CODE FK1 DEPT_CODE ENROLL PK,FK2 REPORT_NUM PK,FK1 SECT_NUM SECTION PK SECT_NUM FK1 C_CODE has generates offers generates is contained in is contained in (1,N) (1,1) (1,1) (1,N) (1,1) (1,1) (1,N) (1,N) (1,1) (1,N) (1,N) (1,1)
Background image of page 4
Data Dictionary and Attributes TABLE NAME ATTRIBUTE NAME CONTENTS TYPE FORMAT RANGE REQUIRED PK OR FK FK REFERENCED TABLE STUDENT STU_NUM Student number CHAR(6) 99999999
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 11

Weekly_Report - Linda Chhay Database Theory and...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online