logo

Database Design- Project Report

16 Pages1938 Words339 Views
   

Added on  2019-11-26

Database Design- Project Report

   Added on 2019-11-26

ShareRelated Documents
Running Head: DATABASE DESIGNDatabase Design[Name of the student][Name of the University]
Database Design- Project Report_1
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 Design- Project Report_2
DATABASE DESIGN2Introduction The 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 administrationoperation 2.To prepare databases with including specific attributes so that designed forms can beused for manipulating data regarding horses, customers, bookings, and meetings 3.To streamline the entire booking and racing business with modify, update, operaterace data, horse data, and meeting data The 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 Design- Project Report_3
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 structural Business Rule 1: Every horse race has a race type. (Races > Race Type)
Database Design- Project Report_4

End of preview

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

Related Documents
Database Design and Implementation
|10
|1020
|304

Database System & Design Assignment - Redberry
|14
|1713
|72

Data Security And Data Integrity Assignment
|14
|2189
|19

Database Design & Development TABLE OF CONTENTS
|31
|5485
|361

Construct Entity Relationship Diagram of Database System
|12
|1971
|474

Database Management System : Doc
|22
|1217
|96