PART 1 :. Since all the shortlisting and swapping is to

Added on - 22 Sep 2019

  • 9

    pages

  • 1988

    words

  • 106

    views

  • 0

    downloads

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 beendropped 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 toattend 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:SERVICESColumnNameDescriptionDatatypeDomainDefault valueRequiredUniqueConstraintIntegrity RuleServiceIDUniquelydefines aserviceNUMBERThreedigitnumber-YYPRIMARYKEY-CategoryType ofServiceVARCHARCharacter stringlength15-NN--TaskNameSpecificserviceVARCHARCharacter stringlength30-NN--MEMBERSColumnNameDescriptionDatatypeDomainDefault valueRequiredUniqueConstraintIntegrity RuleWorkerIDUniquelydefines aMemberNUMBERThreedigitnumber-YYPRIMARYKEY-NameName oftheMemberVARCHARCharacter stringlength15-NN--AddressMember’saddressVARCHARCharacter stringlength30-NN--SuburbsuburbVARCHARCharacter stringlength15-NN--EmailMember’semail idVARCHARCharacter stringlength30-NN--ContactMember’scontactNUMBER10 digitnumber-NN--BiographyA briefaboutMemberVARCHARCharacter stringlength50-NN--ServiceIDTheservice heprovidesNUMBERThreedigitnumber-NNFOREIGNKEYOndeleteDurationDurationVARCHACharacte-NN--
when themember isfreeRr stringlength25GUESTSColumnNameDescriptionDatatypeDomainDefault valueRequiredUniqueConstraintIntegrity RuleGuestIDUniquelydefines aGuestNUMBERThreedigitnumber-YYPRIMARYKEY-NameName oftheMemberVARCHARCharacter stringlength 15-NN--SuburbsuburbVARCHARCharacter stringlength 15-NN--EmailMember’semail idVARCHARCharacter stringlength 30-NN--ContactMember’scontactNUMBER10 digitnumber-NN--EVENTColumn NameDescriptionDatatypeDomainDefaultvalueRequiredUniqueConstraintIntegrity RuleEventIDUniquelydefines aGuestNUMBERThreedigitnumber-YYPRIMARY KEY-OrganiserIDMemberID of theorganiserNUMBERThreedigitnumber-NNFOREIGNKEYOndeleteLeaderIDMemberID of theEventleaderNUMBERThreedigitnumber-NNFOREIGNKEYOndeleteTitleTitle ofthe EventVARCHARCharacter stringlength15-NN--DescriptionDescription of theeventVARCHARCharacter stringlength50-NN--CategoryCategorythe eventfalls inVARCHARCharacter stringlength20-NN--
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document