R6010447 Database Design Concepts

+91-9519066910

Call Us::+61 451 442 632, , WhatsApp:+91-9519066910 ozpaperhelp@gmail.com

Home»
Assignment»
R6010447 Database Design Concepts

R6010447 Database Design Concepts

Rating:

1.0 Introduction

Databases play an integral part in commercial domains, they provide users with a tool in which to store, 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 and end-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 to apply 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 to databases and database design as well as the practical skills to translate that understanding into the 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

2. 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

3 Be able to design, create and document databases

Database development cycle: developing logical data model; implementing a physical data model based on the logical data model; testing the physical data model; comparing model with requirements analysis; user interface e.g. input masks, drop-down lists, option buttons, command buttons

Database software: using appropriate applications software, e.g. Microsoft Access, SQL;database tools eg create tables, add new rows, and alter data, functions, and relational database languages

Tools and techniques: field and table design; validation and verification techniques; forms including such features as dropdown lists or check boxes; reports; queries; macros

Documentation: technical documentation; user documentation.

3.0 Learning Outcomes and assessment criteria:

On successful completion of this unit a learner will:

LO1 Understand databases and data management systems

1.1 analyse the key issues and application of databases within organizational environments.

1.2 critically evaluate the features and advantages of database management systems.

LO2 Understand database design techniques

2.1 analyse a database developmental methodology

2.2 discuss entity-relationship modeling and normalization

LO3 Be able to design, create and document databases

3.1 apply the database developmental cycle to a given data set

3.2 design a fully functional database (containing at least four inter-relational tables) including user interface

3.3 evaluate the effectiveness of the database solution and suggest methods of improvement

3.4 provide supporting user and technical documentation

Teaching and Learning Activities

The module tutor(s) will aim to combine lectures with tutorial activities. This environment will provide opportunities for the student to understand the course material through case study and text and to apply it in a practical way. The intent is to facilitate interactive class activities, and discussion about the significant role of research in a global and local business environment.

Teaching Ethos

The college’s approach towards teaching and learning is simple and effective. The main aim of UKCBC is to assist learners in maximising their potential by ensuring that they are taught clearly and effectively. This will enable students to engage in the learning environment and promote success in both their academic studies and subsequent career.

Methods of Delivery:

LECTURES:

These will be developed around the key concepts as mentioned in the indicative course content and will use a range of live examples and cases from business practice to demonstrate the application of theoretical concepts. This method is primarily used to identify and explain key aspects of the subject so that learners can utilise their private study time more effectively.

SEMINARS:

These are in addition to the lectures. The seminars are designed to give learners the opportunity to test their understanding of the material covered in the lectures and private study with the help of reference books. This methodology usually carries a set of questions identified in advance. Seminars are interactive sessions led by the learners. This method of study gives the learner an excellent opportunity to clarify any points of difficulty with the tutor and simultaneously develop their oral communication skills.

CASE STUDIES:

An important learning methodology is the extensive use of case studies. They enable learners to apply the concepts that they learn in their subjects. The learners have to study the case, analyse the facts presented and arrive at conclusions and recommendations. This assists in the assessment of the learner’s ability to apply to the real world the tools and techniques of analysis which they have learnt. The case study serves as a supplement to the theoretical knowledge imparted through the course work.

Plagiarism:

Any act of plagiarism will be seriously dealt with according to the colleges and awarding bodies’ regulations. In this context the definition and scope of plagiarism are presented below:

Plagiarism is presenting someone’s work as your won. It includes copying information directly from the web or books without referencing the material; submitting joint coursework as an individual effort; copying another student’s coursework; stealing coursework form another student and submitting it as your own work. Suspected plagiarism will be investigated and if found to have occurred will be dealt with according to the college procedure. (For further details please refer to the plagiarism policy and the student code of conduct.)