Lab07 – Entity Attribute List Student Transcript application Start with a simple case STUDENT TRANSCRIPT APPLICATION SYS

[answerhappygod]

Lab07 – Entity Attribute List Student Transcript application
Start with a simple case
STUDENT TRANSCRIPT APPLICATION SYSTEM
The entire system consists of only one report, the STUDENTTRANSCRIPT. Two samples of the report are shown below.
SENECA COLLEGE DATE: 2011 12 31
CAMPUS: Don Mills STUDENTNO. 1234567
STUDENTNAME: G.P.A.2.7
Mary Kim
123 This Street (416)925-2861
No City, ON
A9A 9A9
COURSE DESCRIPTION GRADE FACULTY NAME OFFICE PHONE
PAS145PASCAL 2.0 CS245 TOM JONES 135 7229
COM223 COMMUNICATIONS 3.6 AP142 SALLY ALI 139 7201
MAT111 MATHEMATICS 2.4 CS153 KRIS GOLLY 130 7255
SENECACOLLEGE DATE: 2011 12 31
CAMPUS: Don Mills STUDENTNO. 7654321
STUDENTNAME: G.P.A. 2.6
John Doe
345 That Street (905)491-5050
My City, ON
X1X 1X1
COURSE DESCRIPTION GRADE FACULTY NAME OFFICE PHONE
PAS145PASCAL 2.0 CS245 TOM JONES 135 7229
COM223 COMMUNICATIONS 2.7 AP142 SALLY ALI 139 7201
MAT111 MATHEMATICS 3.0 CS153 KRIS GOLLY 130 7255
IMPORTANT NOTE:
The system is restricted to producing this one form or report.This was done to keep the process needed to develop a database assimple as possible for the first go through.
Submission: Produce a semi final EntityAttribute list for the above system. It can show repeatinggroups
Put the attributes within the entity in a sensible businessorder.
Example STUDENTS[stid, fname, lname, …. (phone), …]
and not STUD[fname stid, lname, postcode, phone, street …]
Hint: Process you might want to use to solve the requirements…
STEP 1 -- IDENTIFY ATTRIBUTES
STEP 2 -- IDENTIFY ENTITIES
STEP 3 -- LIST ATTRIBUTES WITH THE ENTITIES and show repeatingdata within the entities