Database Design & Implementation

Only available on StudyMode
  • Download(s) : 89
  • Published : April 6, 2013
Open Document
Text Preview
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 member information will be stored in member table and party animals will be stored in party animal tables and gold member will be stored in gold member table. Parties’ details information will be stored in party table and party details table. Member’s attendance will be record in attendance table and attendance details. Members will be party animals or gold member is defined depend on attendance time and attendance days and partner number. When member are gathering and are assigned to party, location of party will be sent via SMS to members to gather around. Subscribers will assign services to supply food or drink to party. Subscriber sent invitation message to party with detail party name, venue to member lists. Subscriber’s details information will store in subscriber table and services will be stored at services and services details. Venue name, location, post code will be stored in venue table.

June 2012

KMD Yangon Center

MAY MYAT SWE

4

Database Design and Implementation

Conceptual Data Model
Member ID Attendance ID Venue No

Member

N

Attend

N

Attendance
N

N

Has

1

Venue

Attendance No Attend 1 N N d 1 Party No 1 Consist of 1

Party

N

Invite

Has Invitation ID

Gold Member

Party Animals
1

Invitation
N

Rate

Prefer Food

Prefer Music

Include Send Service ID N 1 Subscriber ID

Services

N

Provide

1

Commercial Subscribers

June 2012

KMD Yangon Center

MAY MYAT SWE

5

Database Design and Implementation

Relational Schema

Member (Member ID, First Name, Last Name, Date of Birth, Contact Address, Entry Date, Member Type, Party No) Gold Member (*Member ID, Gold Member No, Name, Rate, DOB, Contact Address, Entry Date, Member Type) Party Animals (*Member ID, Party Animal No, Name, Rate, DOB, Contact Address, Entry Date, Member Type, Prefer Music type, Prefer foods) Attendance (Attendance ID, *Party No, *Venue No, Entry Date) Attendance Details (Attendance No,...
tracking img