R6010447 Database Design Concepts

R6010447 Database Design Concepts

R6010447 Database Design Concepts

R6010447 Database Design Concepts

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:
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. 
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.
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.
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.)  
java assignment helpjava homework helpprogramming homework helppython assignment helpprogramming assignmentcomputer science assignment helpcomputer science homework helppython homework helpdo my programming homeworkcomputer science assignmentcomputer science homeworkc++ homework help, java programming assignment helpphp assignment helpcoding assignment helpcoding homework helpr programming assignment helpc++ assignment helppay someone to do my programming homeworkc programming assignment helppython programming assignment help




  • Number of views:
  • PRICE :
    AU$ 0.00

Submit Works

Drop File To Upload Or
Assignment Help Australia

Our Top Experts

Karen Betty

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders

Daphne Lip

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders

Mr Roberto Tuzii

Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...

102 - Completed Orders

Harsh Gupta

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders


JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders


Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders

Tan Kumar Ali

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders

Wesenu Irko

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders