6.PDF - WARNING This material has been reproduced and...

This preview shows page 1 - 8 out of 99 pages.

We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Database Systems: Design, Implementation, & Management
The document you are viewing contains questions related to this textbook.
Chapter 16 / Exercise 7
Database Systems: Design, Implementation, & Management
Coronel/Morris
Expert Verified
WARNING This material has been reproduced and communicated to you by or on behalf of Murdoch University in accordance with section 113P of the Copyright Act 1968 ( Act ). The material in this communication may be subject to copyright under the Act. Any further reproduction or communication of this material by you may be the subject of copyright protection under the Act. Do not remove this notice
We have textbook solutions for you!
The document you are viewing contains questions related to this textbook.
Database Systems: Design, Implementation, & Management
The document you are viewing contains questions related to this textbook.
Chapter 16 / Exercise 7
Database Systems: Design, Implementation, & Management
Coronel/Morris
Expert Verified
Logical database design ICT285 Databases Topic 6
In this topic we continue our coverage of the database design process by looking at how we can convert an ERD produced in the conceptual design stage to a set of normalised tables that supports the organisation's business processing requirements. You have already covered the relational model in some depth, and the conversion from an ERD follows some simple rules to ensure you achieve a good design. 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. Unit learning outcomes addressed in this topic Slide 3
After completing this topic you should be able to: Describe the activities in logical database design Convert an ERD to a relational schema in 3NF Validate a relational schema against the business transactions it is required to support Identify and document all integrity constraints for the logical model: required data, attribute domain constraints, entity integrity, referential integrity and enterprise constraints Define appropriate referential actions (‘foreign key rules’) to ensure that referential integrity is maintained when the database is updated, inserted or deleted Document the logical database design in a data dictionary Topic learning outcomes
READING Text, Chapter 6: Transforming data models into database designs Skim the section on Data Types for now (we will come back to it later) You can also skim the section on ‘Representing Ternary and Higher Order Relationships’. And just try to get the basics from ‘Designing for Minimum Cardinality’ Resources for this topic
The first four labs provided you with a lot of practice in creating and querying Oracle tables, and in the previous lab you used Visio to create entity-relationship models. This lab is designed to help you

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture