Report on Database Design

Added on - 26 Nov 2019

  • 16

    pages

  • 1938

    words

  • 105

    views

  • 0

    downloads

Showing pages 1 to 4 of 16 pages
Running Head:DATABASE DESIGNDatabase Design[Name of the student][Name of the University]
DATABASE DESIGN1Table of ContentsIntroduction......................................................................................................................................2Strategic planning factors................................................................................................................2Functional decomposition diagram..................................................................................................3Relationship structural.....................................................................................................................3Entity-relationship diagram.............................................................................................................4Conceptual level business function.................................................................................................5Normalised logical entity-relationship diagram..............................................................................6Normalised entity-relationship diagrams.........................................................................................7Data dictionary...............................................................................................................................10Conclusion.....................................................................................................................................14Bibliography..................................................................................................................................15
DATABASE DESIGN2IntroductionThe report is aimed to provide a planning section with discussing factors, relationshipstructures, ERD diagram, and conceptual level function model. The strategic planning devisesthese parts into the report for depicting how planning and entity-relationship diagram showsalignment of strategy with conceptual diagram. Furthermore, a logical diagram is prepared in thereport formulated from the ERD diagram.Strategic planning factorsThis section obtains organizational initiatives and goals for demonstrating the conceptualand logical diagram. The organizational goals are included in the planning as following:1.To standardize the races and meetings in North Island Racing administrationoperation2.To prepare databases with including specific attributes so that designed forms can beused for manipulating data regarding horses, customers, bookings, and meetings3.To streamline the entire booking and racing business with modify, update, operaterace data, horse data, and meeting dataThe success factors in the operation are identified as consistency in database, retrieval ofdata with appropriate constraints and operating with the retrieved data. For forms, the successconditions are error-free operation with horse data, customer data, and booking data. Horsesshould be registered into race and horse time should be recorded with the forms. Race report’ssuccess conditions are flawless output showing race ID, race name, race types, meeting nameand data, horse name, horse time, jockey name, and owner name. Meeting report will be
DATABASE DESIGN3successful when it shows meeting ID, name, status, capacity, race course name, address, racename, time, type and customer booking counts.The system can have problem areas such as lack of data validation, lacking consistency indatabase, and complexity. The stored data in tables should have proper validation checking sothat during modification or update no data loss issue is encountered. The database should beconsistent with each attribute linked with ERD. The database should have minimal complexity inorder to run the entire process with simple queries and functions.Functional decomposition diagramFigure 1: Functional decomposition diagram(Source: Created by author)Relationship structuralBusiness Rule 1: Every horse race has a race type. (Races > Race Type)
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