USA: +1(715)227-4880, UK: +44-7896988486, AU:+61-452503850


Computing Skills Assignment Help

Matlab Assignment Help

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, 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 otherssuch as programming, systems analysis, HCI, as well as embracing issues of compatibility andend-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

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 designerworking 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 databaselanguages

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

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.

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

2.3.1 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 plagiarismwill 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.) 



The module will be assessed meeting all the LO as specified by the awarding body, Ed Excel.

Please read the instructions carefully while addressing the tasks specified. 

Contribution: 100% of the module

Outline Details: Individual report approx 4500 words.   Details enclosed in the assignment brief. 

6.0   Assignment Brief Section



Unit Number and title

Unit 17:Database Design Concepts


BTEC HND Computing and Systems Development (Level 4)

Term Start Date

05 June 2017

Assignment hand out date


Deadline/ Hand-in

13 August 2017


Assignment title

Case Study of Shoengalleric Art Gallery

Purpose of this assignment:

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.

TASK 1 to TASK 3: You are required to follow the instructions as specified towards each task and support with research by using supportive materials like books, websites, etc., and give feedback on the findings by relating your arguments to the relevant case study as specified towards each task. Your report should fully follow the Harvard Referencing model.


LO1 : Task – 1:

The objective for this task is to address and exhibit understand databases and data

management systems.You are required to carry out research by using supportive materials like books, websites, etc., and give a feedback of the findings on AC1.1&1.2.  The answers need to be reflected to the general Database Management Systems Concepts. Answers without application to an organization or without examples will be marked as Resubmission.

(LO1 A.C 1.1 and A.C 1.2)



1.1-         Analyze the key issues and application of databases within organizational environments


1.2-         Critically evaluate the features and advantages of database management systems.



TASK 2: 


LO2- Task 2  Understand database design techniques


The objective for this task is to address and exhibit understand database design techniques.You are required to carry out research by using supportive materials like books, websites, etc., and give a feedback of the findings on A.C 2.1 and A.C 2.2. The answers need to be reflecting the case study. Answers without application to an organization or without examples will be marked as Resubmission.


Case Study


Shoengalleric is an Art Gallery based in China which was established in 2010. Since then, the company has grown steadily and now has galleries in operation in the main cities in China. The Gallery has arts of different subjects. The Gallery fulfil the requirements of diverse clientele. They have a workforce of more than 500 staff operational in all the branches.

However, the company is now so large that more and more administrative staff are being employed to cope with the ever-increasing amount of paperwork due to the outdated office based systems. Furthermore, the communication and sharing of information within the company is poor. The Director of Company, Mr. Peng Wang feels that too many errors are being made and that the success of his company will be short-lived if he does not do something to remedy the situation. He knows that a database could help in part to solve the problem and has approached you to help in creating a database application to support the running of the Shoengalleric Art Gallery operations. 

The Director, Mr. Peng Wang has provided the following hierarchy and brief description of how Shoengalleric Art Gallery operates:



  • Number of views:
  • PRICE :
    AU$ 60.00
Security Code  
Urgent Assignment Help

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

Lizzy Darley

I'm Lizzy, full time education specialist in English, Essay Writing, Economics and Maths. Having Assi...

109 - Completed Orders


HSC PREPARATION I specialise in English coaching programs for HSC students. My personalised and results-...

202 - Completed Orders