CS251-1301B-03 Fundamentals of Database Systems
Phase 1 -5 Individual Project
Robert
March 24th, 2013
Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18
Project Outline
My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks. We will perform counter sales, contractor and walk-in customer kitchen and bath design, templates, fabrication, installation, and follow-up. To run efficiently (or at all) we must have a centralized DBMS with access for all employees in…show more content… The emphasis is on ensuring that the system components along with the data is prepared and disposed of accordingly (Brownfield, n.d.). Describe the specific tasks that should be taken at each step in the database development for your selected database: * Requirement Analysis – Determine the information needs of my organization so that I can develop a database. What do my employees need in the way of accessing, storing and writing information? Show activity steps in each department. * Logical Design – Create a conceptual model (an entity-relationship diagram) based on findings in the requirements analysis that shows tables, fields, and primary keys of the database and show table relationships (keys). Tables must then be normalized to resolve problems and maximize efficiency. * Physical Design – Find ways to maximize database efficiency. Pay attention to the two slowest operations in an RDBMS – retrieving and writing data. * Implementation – Install the system. I expect this will include all hardware, software and labor in actual installation and then training the employees on system use. * Monitoring, Modification, and Maintenance -- Maintain the systems hardware and software with updates, upgrades. Train employees on new features and upgrades. Monitor for problems with the system (Brownfield, n.d.).
A description of the 3 steps in database creation (including conceptual, logical, and physical data modeling) as it relates to your selected
