logo

Exploring the Gardens Database

   

Added on  2019-09-22

9 Pages1988 Words138 Views
 | 
 | 
 | 
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)
Exploring the Gardens Database_1

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--
Exploring the Gardens Database_2

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--
Exploring the Gardens Database_3

End of preview

Want to access all the pages? Upload your documents or become a member.