Database Design & Implementation
1
Database Design and Implementation
Candidate Name: Course Name: Date of Submission: Authorization:
MAY MYAT SWE Database Design and Implementation 7, April 2012 University of Greenwich
June 2012
KMD Yangon Center
MAY MYAT SWE
2
Database Design and Implementation
Table of Contents No Description Page
Assumption ........................................................................................ 3 1. 2. 3. 4. 5. 6. Conceptual Data Model ...................................................................... 4 Relational Schema .............................................................................. 5 Normalization ..................................................................................... 6 SQL Code and Testing........................................................................ 12 Screen Design and Testing .................................................................. 18 Report Design and Testing .................................................................. 27
June 2012
KMD Yangon Center
MAY MYAT SWE
3
Database Design and Implementation
Assumption Online clubbing and party, I assume that member will register first who want to attend online clubbing and party, and they will need to provide member first name, last name, date of birth, gender, address. As soon as they attend party, they regard as standard member. After they regularly attend party they become full member. There will be two type of full member. One is goal member and other is party animals. In member table, member type will be used to define member who is standard or full member. If full member attend big parties are called party animals and if members become party animals, musical and food preference will be stored for party animals table. When member become gold member, they will bring more than two people to party. Gold member are rated as one or two stars depending on how many people they will bring to party. Standard
Database Design and Implementation
Candidate Name: Course Name: Date of Submission: Authorization:
MAY MYAT SWE Database Design and Implementation 7, April 2012 University of Greenwich
June 2012
KMD Yangon Center
MAY MYAT SWE
2
Database Design and Implementation
Table of Contents No Description Page
Assumption ........................................................................................ 3 1. 2. 3. 4. 5. 6. Conceptual Data Model ...................................................................... 4 Relational Schema .............................................................................. 5 Normalization ..................................................................................... 6 SQL Code and Testing........................................................................ 12 Screen Design and Testing .................................................................. 18 Report Design and Testing .................................................................. 27
June 2012
KMD Yangon Center
MAY MYAT SWE
3
Database Design and Implementation
Assumption Online clubbing and party, I assume that member will register first who want to attend online clubbing and party, and they will need to provide member first name, last name, date of birth, gender, address. As soon as they attend party, they regard as standard member. After they regularly attend party they become full member. There will be two type of full member. One is goal member and other is party animals. In member table, member type will be used to define member who is standard or full member. If full member attend big parties are called party animals and if members become party animals, musical and food preference will be stored for party animals table. When member become gold member, they will bring more than two people to party. Gold member are rated as one or two stars depending on how many people they will bring to party. Standard