Database
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Database as PDF for free.
More details
- Words: 284
- Pages: 6
F.4 Computer and Info. Tech. Database
Data Organization Student Record
How to proceed these data?
Teacher Record Chan Siu Man Teacher Record Name: Wong Tai Man Gender: M Student Record Name: Wong Siu Man Gender: StudentID: 1D25 M Teacher Name: Lee Susan Record Gender: F TeacherID: WTM DOB: 01/01/1988 Student Name:WSM F Hui Peter Record Gender: TeacherID: DOB: 02/02/1978 Address: … Name:4B01 M Chan Tai Man Gender: StudentID: DOB: 03/03/1978 Address: … Record … Teacher Attendance Gender: M TeacherID: HP DOB: 04/04/1990 Address: … … Teacher TeacherID: WSM Attendance Record 5C31 DOB: StudentID: 05/05/1980 Address: … … WSM Late Arrival Record Date: TeacherID:21/09/2005 Students’ DOB: 10/01/1988 Address: … … Date: Name: Arrival Time: 7:40a.m.22/09/2005 Chan Tai Man… Address: … Arrival Time: Departure Time: 4:50p.m.7:40a.m.5C31 StudentID: … Departure Time: 4:50p.m.21/09/2005 Date: Name:
Arrival Time:
8:40a.m.
Data Organization Students Record Name
G StudentID
Chan Tai Man Chan Siu Man ……
M M
5C31 1D25
DOB 10/01/1988 01/01/1988
Addr … …
Teachers Record Name Wong Tai Man Wong Siu Man …… …
G TeacherID M F
WTM WSM
DOB 02/02/1978 03/03/1978
Addr …
Students’ Late Arrival Record StudentID Name 5C31
… …
Wong Tai Man
ArrivalTime 21/09/2005 8:40a.m.
DATABASE !
Database
Conceptual / Logical View Database
Table Record
Field
Database
Structural View Database Table
Record
Table
Record …… Field
Field
Field
Data
Data
……
……
Record Field
…… …… ……
Database
A database is a collection of related tables A table is a collection of related records A record is a group of related fields A field holds one data Tables in the same database can have different structures Records in the same table MUST have the same structure
Data Organization Student Record
How to proceed these data?
Teacher Record Chan Siu Man Teacher Record Name: Wong Tai Man Gender: M Student Record Name: Wong Siu Man Gender: StudentID: 1D25 M Teacher Name: Lee Susan Record Gender: F TeacherID: WTM DOB: 01/01/1988 Student Name:WSM F Hui Peter Record Gender: TeacherID: DOB: 02/02/1978 Address: … Name:4B01 M Chan Tai Man Gender: StudentID: DOB: 03/03/1978 Address: … Record … Teacher Attendance Gender: M TeacherID: HP DOB: 04/04/1990 Address: … … Teacher TeacherID: WSM Attendance Record 5C31 DOB: StudentID: 05/05/1980 Address: … … WSM Late Arrival Record Date: TeacherID:21/09/2005 Students’ DOB: 10/01/1988 Address: … … Date: Name: Arrival Time: 7:40a.m.22/09/2005 Chan Tai Man… Address: … Arrival Time: Departure Time: 4:50p.m.7:40a.m.5C31 StudentID: … Departure Time: 4:50p.m.21/09/2005 Date: Name:
Arrival Time:
8:40a.m.
Data Organization Students Record Name
G StudentID
Chan Tai Man Chan Siu Man ……
M M
5C31 1D25
DOB 10/01/1988 01/01/1988
Addr … …
Teachers Record Name Wong Tai Man Wong Siu Man …… …
G TeacherID M F
WTM WSM
DOB 02/02/1978 03/03/1978
Addr …
Students’ Late Arrival Record StudentID Name 5C31
… …
Wong Tai Man
ArrivalTime 21/09/2005 8:40a.m.
DATABASE !
Database
Conceptual / Logical View Database
Table Record
Field
Database
Structural View Database Table
Record
Table
Record …… Field
Field
Field
Data
Data
……
……
Record Field
…… …… ……
Database
A database is a collection of related tables A table is a collection of related records A record is a group of related fields A field holds one data Tables in the same database can have different structures Records in the same table MUST have the same structure
