lect02.ppt

Lecture 2 Yesterday, we touched on the concept of a Project Plan This leads to Project Planning and Control So for the next few minutes, we will be overviewing this important feature of ANY project. And then we will move onto Database Design Project Planning Project Planning and Control Part of the project you will complete will be subject to Project Planning. One member of each group will become responsible for administering the resources - time and personnel skills. This person will be responsible that the 3 milestones are completed in the timescale and that the milestone documents are complete The following overheads give you some idea of the scope of this very important component of ANY project Project Planning Project Planning - Gannt Chart PERT Diagram Data Base Design Data Base Design Reduce data redundancy. Provide stable data structures that can be readily changed with changing user requirements. Allow users to make ad hoc requests for data. · Maintain complex relationships between data elements. Support a large variety of decision needs Hawryszkiewycz I J (1984) Database Analysis and Design p 2 End Product of Data Base Design Business Functions and Processes Business Activities Business Entities Critical Success Factors Design Criteria Database Design 3 Schema Architecture 3 Schema Architecture 3 Schema Architecture Database Design Database Design Data Modelling Data Modelling Entities The designation of a ‘thing’ about which data is to be collected stored processed Typical Entities : persons, items, buildings, stocks, vehicles, jobs, books, libraries Entity Relationships Type Shown As Example 1. One to One 1:1 Driver Licence Watch For : OPTIONAL 2. One to Many 1:M Subject S