Database Structure And Design Assignment

Running head: Database
DATABASE
Name of the Student
Name of the University
Author Note

DATABASE1
Table of Contents
1. Given the following STUDENT table which contains a repeating group:.........................2
2. For the STUDENT table perform the following:................................................................2
a. Normalize the table into 1NF, 2NF, and 3NF.................................................................2
b. List of the primary keys, foreign keys, and all fields for each table you identify at each
normal form level...................................................................................................................3
c. Creating ERD using Chen’s Notation:............................................................................4
d. Create the structure for each table identified in the ERD...............................................4
3. Using MS Access to implement the system:......................................................................6
Creating forms to populate/enter data:...................................................................................6
Queries:..................................................................................................................................7
Reports:..................................................................................................................................9
4. Data Dictionary:................................................................................................................11
Bibliography:............................................................................................................................14

DATABASE2
1. Given the following STUDENT table which contains a repeating
group:
STUDENT (STUDENT-NUMBER, STUDENT-NAME, MAJOR, CLASSIFICATION,
TOTCRDITS, GPA, COURSE-PREFIX, COURSE-DESC, CREDIT_HOURS, GRADE,
ADVISORNUMBER, ADVISOR-NAME)
2. For the STUDENT table perform the following:
a. Normalize the table into 1NF, 2NF, and 3NF
UNF 1NF 2NF 3NF
Un normalized data Identify repeating
groups
Identify partial
dependencies
Non key dependencies
STUDENT-NUMBER,
STUDENT-NAME,
MAJOR,
CLASSIFICATION,
TOTCRDITS, GPA,
COURSE-PREFIX,
COURSE-DESC,
CREDIT_HOURS,
GRADE,
ADVISORNUMBER,
ADVISOR-NAME
STUDENT-NUMBER,
STUDENT-NAME,
MAJOR,
CLASSIFICATION,
TOTCRDITS, GPA
STUDENT-NUMBER,
COURSE-NUMBER,
COURSE-PREFIX,
COURSE-DESC,
CREDIT_HOURS,
GRADE,
ADVISORNUMBER,
ADVISOR-NAME
STUDENT-NUMBER,
STUDENT-NAME,
MAJOR,
CLASSIFICATION,
TOTCRDITS, GPA
STUDENT-NUMBER,
COURSE-NUMBER,
ADVISORNUMBER,
COURSE-PREFIX,
COURSE-DESC,
CREDIT_HOURS,
GRADE.
STUDENT-NUMBER,
STUDENT-NAME,
MAJOR,
CLASSIFICATION,
STUDENT-NUMBER,
TOTCRDITS, GPA,
CREDIT_HOURS, GRADE.
COURSE-NUMBER,
COURSE-PREFIX,
COURSE-DESC,
ADVISORNUMBER,

DATABASE3
ADVISORNUMBER,
ADVISOR-NAME
ADVISOR-NAME
STUDENT-NUMBER,
COURSE-NUMBER.
ADVISORNUMBER,
Date.
b. List of the primary keys, foreign keys, and all fields for each table you identify at
each normal form level
The primary keys are shown in bold and foreign keys in Italic and underlined.
STUDENT (STUDENT_NUMBER, STUDENT_NAME, MAJOR, CLASSIFICATION)
MARKS (STUDENT_NUMBER, TOTCRDITS, GPA, CREDIT_HOURS, GRADE.)
COURSE (COURSE_NUMBER, COURSE_PREFIX, COURSE_DESC)
ADVISOR (ADVISOR_NUMBER, ADVISOR_NAME)
STUDENT_ENROLMENT_COURSE (STUDENT_NUMBER, COURSE_NUMBER,
ADVISOR_NUMBER)