This is the first of three topics that deal specifically with database design as a process. Database design can be divided into three basic stages: conceptual, logical and physical. The conceptual designphase (this topic) constructs a model of the enterprise’s data needs independent of any database model. This ensures firstly that design can progress without the need for compromise due to limitations in the data model, and secondly that the data model most appropriate to the particular enterprise’s requirements can be selected when the requirements are more fully known. About this topic
1.Explain the importance of databases in information management 2.Demonstrate an understanding of relational database principles and theory 3.Demonstrate practical skills in using SQL 4.Demonstrate practical skills in data modelling using entity-relationship modelling 5.Demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF 6.Create a database from a given design using a DBMS and implement specified constraints using appropriate tools and approaches 7.Explain and implement security as it applies in the database environment. 8.Explain the issues and approaches involved in the processing of concurrent database transactions 9.Describe common architectural approaches to database distribution 10.Explain the role of databases in Business Intelligence 11.Describe some non-relational database approaches, and likely future trends in database technologies and applications.
In today’s lab you will practice creating several ERDs that demonstrate some of the typical patterns found in data modelling. We will use Microsoft Visio for this. Visio is a powerful drawing tool that can be used to create many different types of diagrams, including ERDs. It is a useful tool for ER modelling as it not only