Unit17 Database Design Concepts

Unit17 Database Design Concepts

Unit17 Database Design Concepts,Databases play an integral part in commercial domains, they provide users with a tool in which tostore, model and retrieve data. Database development is fundamental in the area of computingand ICT within organisational contexts. Database Management Systems (DBMS) provide thesystems

About the Book

Unit17 Database Design Concepts 

1.0 INTRODUCTION 

Databases play an integral part in commercial domains, they provide users with a tool in which tostore, model and retrieve data. Database development is fundamental in the area of computing and ICT within organisational contexts. Database Management Systems (DBMS) provide the systems, tools and interfaces by which the organization can manage their information and use it to assist in the effective running of the organization. Databases offer many links to others such as programming, systems analysis, HCI, as well as embracing issues of compatibility addend-user interfacing.

This unit explores database architecture, DBMS and the use of databases in an organizational context. Database design techniques are investigated and successful learners will be able toapply theoretical understanding to design, create and document a database system.

1.1 Aim:

To give learners opportunities to develop an understanding of the concepts and issues relating todatabases and database design as well as the practical skills to translate that understanding intothe design and creation of complex databases.

1.2 Objectives:

On successful completion of this unit a learner will :

1.Understand databases and data management systems

  1. Understand database design techniques

3.Be able to design, create and document databases.

2.0 Unit / Module Content

1 Understand databases and data management systems

Databases: database architectures; files and record structures; physical and logical views of data; advantages of using databases; reduction of data redundancy; data consistency (validity, accuracy, usability and integrity); independence of data; data sharing possibilities; security; enforcement of standards; database utilities; data dictionaries; query languages; report generators.

Databases in an organizational context: database applications; role of the database

Administrator; key organizational issues eg integrity, security, recovery, concurrency; industry standards e.g. Microsoft SQL, Oracle, Sybase, dBase

Database Management Systems (DBMS): structures; purposes; features and advantages;Applications; methods of data organization and access

2 Understand database design techniques

Database design methods and methodology: requirements analysis; database designer working with expert in domain development area; requirement specification; logical design e.g. relational databases, tables; physical design e.g. data elements, data types, indexes; data analysis and design within systems analysis; database design within a system development methodology

Relational database design: tables, relations, primary/foreign/compound keys; entity relationship modeling; normalization theory to third normal form

Book Club Resources
Disclosure of Material Connection: Some of the links in the page above are "affiliate links." This means if you click on the link and purchase the item, I will receive an affiliate commission. I am disclosing this in accordance with the Federal Trade Commission's 16 CFR, Part 255: "Guides Concerning the Use of Endorsements and Testimonials in Advertising."