ContentsINTRODUCTION.................................................................................................................................2CONTEXT DIAGRAM..........................................................................................................................2DFD LEVEL 0......................................................................................................................................2ATTRIBUTES AND ENTITIES...............................................................................................................2NORMALIZATION..............................................................................................................................2ER DIAGRAM.....................................................................................................................................2RELATIONAL SCHEMA.......................................................................................................................2IMPLEMENTATION............................................................................................................................21.TABLE STRUCTURE IN DESIGN VIEW.....................................................................................22.RELATIONSHIPS.....................................................................................................................23.QUERY IN DESIGN VIEW........................................................................................................24.SAMPLE DATA IN FORMS AND REPORTS...............................................................................25.SAMPLES OF OUTPUT FROM THE SYSTEM (TICKETS, QUERIES AND REPORTS).....................2IMPROVEMENTS...............................................................................................................................2CONCLUSION....................................................................................................................................2REFERENCES......................................................................................................................................21 | P a g e
INTRODUCTIONThe report is about an event management system that will be designed to hold the information of:A.VenuesB.ArtistsC.Ticket bookingsD.EventsAs given in the requirements that the events or performances will include different types of events and artist. Typical types of event are concerts, variety shows, comedy shows etc. For a concert, the artist will be the band name; for a comedy show the comedian/comedienne; for a variety show the leading name will appear. Thus after analysis of the given requirements, there came up certain hidden requirements or we can say non-functional requirements and functional as well. So apart from the stated requirements, the information related to other aspects like address, date, who will perform where, who booked which ticketand other general information will also be stored in the database. Thus the document below contains visual designs and database references that have been designed to meet the user requirements and build it into an actual product. Along with this some enhancements have also been suggested for future expansion and improvements because with the time, the size and complexity of the database will also increase. So to keep the system updated with the technological changes and changing user requirements, the improvements should always take place. 2 | P a g e
CONTEXT DIAGRAMThis is the context diagram of the system that has been designed to give an overview that how the system will look and communicate. DFD LEVEL 0The diagram given below is an enhancement of the context diagram and is called DFD level 0 diagram. It contains a more detailed view of the system and shows or visualizes what and how many data stores and other information will be seen in the actual system. 3 | P a g e
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
ArtisT-MUSIC Management Systemlg...
|15
|861
|125
MIS605 Systems Analysis and Designlg...
|23
|2770
|209
Database Systemslg...
|7
|609
|235
Entity Relationship Diagram, Data Flow Diagrams, Use Cases, Activity Diagrams, Documentation and Project Plan for TGE Systemlg...
|12
|2218
|360
Database Design and Implementation | Normalizationlg...
|11
|1603
|21
Database Design for College: ER Diagram, Summary, and Implementation Planlg...