PART 1: The Event Table
Added on -2019-09-22
SCHEMA: SERVICES (serviceID, Category, Task Name) MEMBERS (WorkerID, Name, Address, Suburb, Email, Contact, Biography, ServiceID, Duration) GUESTS (GuestID, Name, Suburb, Email, Contact) EVENT (EventID, OrganiserID, LeaderID, Title, Description, Category, Date, Location, Postcode, Instruction, Number of People) HELPER (HelperID, EventID) ATTENDENTS (Attendent
| 9 pages
| 1988 words
| 334 views
Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 3 of 9 pages
PART 1:Since all the shortlisting and swapping is to be handled internally so the relations for them has been dropped as they are no longer required. A new relation Guests is added to the database for those who are not a member and are eager to attend the event.A helper table is added for the volunteers for the event.Some attributes that are added to the EVENT table includes OrganiserID, LeaderID, Category, Postcode and Instructions.SCHEMA:SERVICES (serviceID, Category, Task Name)MEMBERS (WorkerID, Name, Address, Suburb, Email, Contact, Biography, ServiceID, Duration)GUESTS (GuestID, Name, Suburb, Email, Contact)EVENT (EventID, OrganiserID, LeaderID, Title, Description, Category, Date, Location, Postcode, Instruction, Number of People)HELPER (HelperID, EventID)ATTENDENTS (AttendentID, EventID)
PART 2:SERVICESColumn NameDescriptionData typeDomainDefault valueRequiredUniqueConstraintIntegrity RuleServiceIDUniquely defines a serviceNUMBERThree digit number-YYPRIMARY KEY-CategoryType of ServiceVARCHARCharacter string length 15-NN--TaskNameSpecific serviceVARCHARCharacter string length 30-NN--MEMBERSColumn NameDescriptionData typeDomainDefault valueRequiredUniqueConstraintIntegrity RuleWorkerIDUniquely defines a MemberNUMBERThree digit number-YYPRIMARY KEY-NameName of the MemberVARCHARCharacter string length 15-NN--AddressMember’s addressVARCHARCharacter string length 30-NN--SuburbsuburbVARCHARCharacter string length 15-NN--EmailMember’s email idVARCHARCharacter string length 30-NN--ContactMember’s contactNUMBER10 digit number-NN--BiographyA brief about MemberVARCHARCharacter string length 50-NN--ServiceIDThe service he providesNUMBERThree digit number-NNFOREIGN KEYOn deleteDurationDuration VARCHACharacte-NN--
when the member isfreeRr string length 25GUESTSColumnNameDescriptionData typeDomainDefault valueRequiredUniqueConstraintIntegrity RuleGuestIDUniquely defines a GuestNUMBERThree digit number-YYPRIMARY KEY-NameName of the MemberVARCHARCharacter string length 15-NN--SuburbsuburbVARCHARCharacter string length 15-NN--EmailMember’s email idVARCHARCharacter string length 30-NN--ContactMember’s contactNUMBER10 digit number-NN--EVENTColumn NameDescriptionData typeDomainDefault valueRequiredUniqueConstraintIntegrity RuleEventIDUniquely defines a GuestNUMBERThree digit number-YYPRIMARY KEY-OrganiserIDMemberID of the organiserNUMBERThree digit number-NNFOREIGNKEYOn deleteLeaderIDMemberID of the Event leaderNUMBERThree digit number-NNFOREIGNKEYOn deleteTitleTitle of the EventVARCHARCharacter stringlength 15-NN--DescriptionDescription of the eventVARCHARCharacter stringlength 50-NN--CategoryCategory the event falls inVARCHARCharacter stringlength 20-NN--
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan