Unit 2 Contemporary Hospitality Industry Assignment

This is a solution of Unit 17 Database Design Concepts that describes about Developing business

Unit 17 Database Design Concepts

Unit 17 Database Design Concepts

Intriduction

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 organisation can manage their information and use it to assist in the effective running of the organisation. Databases offer many links to other areas 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.

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.

 Key Objectives:

  1. Understand databases and data management systems
  2. Understand database design techniques
  3. Be able to design, create and document databases.

Learning Outcomes and assessment criteria:

LO1 Understand databases and data management systems

1.1 analyse the key issues and application of databases within organisational 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 modelling and normalisation

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.

Knowledge and Understanding:

  • Role of Database Management Systems in 21st century Enterprise application.
  • What are the key concepts and issues to design DBMS systems?
  • Be able to analyse the user requirements and design a DBMS system accordingly.
  • Be able to create complex database system.
  • Creating Database physical design.
  • Validation and verification of designed database system.
  • Documentation to support data analysis and design for database system.

Indicative 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 organisational context: database applications; role of the database administrator; key organisational issues eg integrity, security, recovery, concurrency; industry standards eg Microsoft SQL, Oracle, Sybase, dBase

Database Management Systems (DBMS): structures; purposes; features and advantages; applications; methods of data organisation 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 eg relational databases, tables; physical design eg 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 modelling; normalisation 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 eg input masks, drop-down lists, option buttons, command buttons

Database software: using appropriate applications software, eg Microsoft Access, SQL; database tools eg create tables, add new rows, alter data, functions, 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

Programme Specification

Accrediting Body:  EDEXCEL

Course: BTEC HND IN Computing and Systems Development

Unit: 17 Database Design Concepts

Wk Lecture Schedule Outcome of session Activity/seminar and formative assessment Resources
1

 

Introduction to Database Design Concepts.

 

Introduction to the module, mode of assessment, awareness of the awarding body, assessment criteria and the mode of assessment.  

Role play and individual induction, helping to know each other.

 

Module handbook.

 

2

 

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); By the end of the session you will be able to Understand:

  • DBMS architecture.
  • Advantages and Disadvantages DBMS
  • Data consistency
  • Data Security issues
  • Data Dictionaries
  • Query Languages

 

Case study, tutorial and addressing the partly learning outcome 1.1

Practical –

Base Introduction

·      Help system

·      Free online support

·      Paid support and training

·      Illustrations

·      Icons

 

Power point slides from: Connolly T and Begg C, and C J Date, Research

 

3

 

Databases: independence of data; data sharing possibilities; security; enforcement of standards; database utilities; data dictionaries; query languages; report generators

 

By the end of the session you will be able to Understand:

  • DBMS architecture.
  • Advantages and Disadvantages DBMS
  • Data consistency
  • Data Security issues
  • Data Dictionaries
  • Query Languages

 

Case study, tutorial and addressing the partly learning outcome 1.1

Practical –

Introduction to Base

·      Introduction

·      Base – a container for database content

·      Data input using forms

·      Data input directly into a table

·      Queries – getting information on data in tables

·      Reports – presentation of data

 

Power point slides from: Connolly T and Begg C, and C J Date, Research

 

4

 

Databases in an organisational context: database applications; role of the database administrator; key organisational issues eg integrity, security, recovery, concurrency; industry standards eg Microsoft SQL, Oracle, Sybase, dBase Learners will be able to know the DBMS solution for Enterprise application and Industry standards DBMS software. Case study, tutorial and addressing the partly learning outcome 1.1  and 1.2

Practical –

Creating a Database

·      General notes on the creation of a database

·      New database using the internal HSQL engine

·      Accessing external databases

Ø  MySQL databases

Ø  dBase databases

Ø  Spreadsheets.

Ø  Thunderbird address book

 

Power point slides from: Connolly T and Begg C, and C J Date, Research

 

5

 

Database Management Systems (DBMS): structures; purposes; features and advantages; applications; methods of data organisation and access Learners’ will be able to understand the following:

·         Structures of DBMS

·         Application of DBMS

·         Access of Data.

Case study, tutorial and addressing the partly learning outcome 1.2

Practical –

Creating Table Using Base

·      General information on tables

·      Relationships between tables

·      Creating tables

·      Linking tables

·      Entering data into tables

 

 

Course Notes, Research

6

 

Database design methods and methodology: requirements analysis; database designer working with expert in domain development area; requirement specification; logical design eg relational databases, tables; Learners will be able to apply constraints in Logical and design and develop relational database solution. Case study, tutorial and addressing the partly learning outcome 2.1

Practical – Using Smart Draw

  • Use Case Diagram
  • Data Flow Diagram

 

Course Notes, Practical
7

 

Database design methods and methodology: physical design eg data elements, data types, indexes; data analysis and design within systems analysis; database design within a system development methodology

 

Learners’ will be able to know and apply SSADM methodology, different data types to design database. Case study, tutorial and addressing the partly learning outcome 2.1

Practical – Using Smart Draw

  • Entity Relationship Diagram
  • Entity Life History
Course Notes, Practical
8

 

Relational database design: tables, relations, primary/foreign/compound keys; entity relationship modelling; normalisation theory to third normal form Learners’ will be able to design database by applying normalization,  create logical tables with primary, foreign and compound keys and ER modeling. Tutorial and address partly the LO 2.2

Practical –

Normalisation (Bottom Up)

1st and 2nd using Ms Excel

Course Notes, and Lab Practical, online video tutorial.
9

 

Relational database design: tables, relations, primary/foreign/compound keys; entity relationship modelling; normalisation theory to third normal form Learners’ will be able to design database by applying normalization,  create logical tables with primary, foreign and compound keys and ER modeling. Tutorial and address partly the LO 2.2

Practical –

Normalisation (Bottom Up)

3rd using Ms Excel

Course Notes, and Lab Practical, online video tutorial.
10

 

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 eg input masks, drop-down lists, option buttons,command buttons. See more : Unit 6 Contemporary Issues In Travel And Tourism

 

Learners’ will be able to Develop physical database tables and forms using MS Access 2007. Tutorial and address the LO 3.1

Practical –

Reflecting Case Study creating Table Using Base

·      General information on tables

·      Relationships between tables

·      Creating tables

·      Linking tables

·      Entering data into tables

Course Notes, and Lab Practical, online video tutorial.
11

 

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

 

Learners’ will be able to Develop database queries and reports MS Access 2007. Tutorial and address the LO 3.2

Practical –

·      Creating forms

·      A simple form

·      Toolbars for form design

·      Setting up a form with the Form Navigator

·      Creating a form using a form field

·      Form properties

·      Properties of controls

·      Text field

·      Numeric field

·      Date field

·      Time field

·      Currency field

·      Formatted field

·      List box

·      Combo box

·      Check box

·      Option button

·      Image control

·      Pattern field

·      Table control

·      Label field

·      Push button

·      Navigation bar

·      Main forms and sub forms

Course Notes, and Lab Practical, online video tutorial.
12

 

Tools and techniques: field and table design; validation and verification techniques; Learners’ will be able to apply validation and verification techniques for the developed database solution.

 

Tutorial and address the LO 3.3

Practical –

·      General information on queries

·      Entering queries

·      Creating queries using the graphical user interface

·      Using functions in a query

·      Relationship definition in the query

·      Query enhancement using SQL Mode

·      Using an alias in a query

·      Subqueries

Queries as source tables for queries

Course Notes, and Lab Practical, online video tutorial.
13 Tools and techniques: forms including such features as dropdown lists or check boxes; reports; queries; macros

 

Learners’ will be able to apply validation and verification techniques for the developed database solution.

 

Tutorial and address the LO 3.3

Practical –

·      Creating reports using the Report Builder

·      The user interface of the Report Builder

·      General properties of fields

·      Special properties of graphical controls

Course Notes, and Lab Practical, online video tutorial.
14 Documentation: technical documentation Learners’ will be able to create documentation for developed database solution and user of the application. Tutorial and address the LO 3.4

Practical –

Creating Technical Documentation using MS Word

Course Notes, and Lab Practical, online video tutorial.
15 Documentation: user documentation Learners’ will be able to create documentation for developed database solution and user of the application. Tutorial and address the LO 3.4

Practical –

Creating Technical Documentation using MS Word

Course Notes, and Lab Practical, online video tutorial.
16 Revision Revision Revision Revision
17 Revision Revision Revision Revision
18 Revision Revision Revision Revision
19 Assignment Support Assignment Support Assignment Support Assignment Support
20 Assignment Support Assignment Support Assignment Support Assignment Support
21 Assignment Support Assignment Support Assignment Support Assignment Support

 Recommended text and links

Books

Avison D and Fitzgerald G – Information Systems Development: Methodologies, Techniques and Tools (McGraw Hill Higher Publishing Company, 2006) ISBN 0077114175

Chao L – Database Development and Management (CRC Press, 2006) ISBN 0849392381

Connolly T and Begg C – Database Systems: A Practical Approach to Design, Implementation and Management (Addison Wesley, 2004) ISBN 0321210255

Howe D – Data Analysis for Database Design (Butterworth-Heinemann Ltd, 2001) ISBN 0750650869

Kroenke D – Database Concepts, 2nd Edition (Prentice Hall, 2004) ISBN 0131451413

Ritchie C – Relational Database Principles (Thomson Learning, 2002) ISBN 0826457134

Websites

www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

www.geekgirls.com/menu_databases.htm

www.smart-it-consulting.com/database/progress-database-design-guide/

Lecturer: Mohammed Hasan

Campus: Lords house

Contact details: hasan@ukcbc.co.uk

Assessment:

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.

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:

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. See More : BTEC Higher National Diploma In Mechanical Engineering- VT720

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

Assessment:

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.

ASSESSEMENT and ASSIGNMENT BRIEF

Unit 17 : Database Design Concepts                                                     UNIT CODE: R/601/0447
Learning Hours:  45 Hours.                                                           Self-learning hours:  90 hours.
Course: HND CSD – Level 4                                                               Credits: 15
Term:
Lecturer: Mohammed Hasan Verifier:
Learners Name
Registration Number
Learners Declaration: I certify that the work submitted for this unit is my own:
Signed:
Hand out Date:    05/10/2013

Submission Date: 22/01/14

The Following Sections to be completed by the assessor:

Center Name: UKCBC
Center Number:

Please note that the assessors signature below denotes conformation that he/she has in no way influenced the outcome of the assessment:

Assessors Name:
Assessors Signature:
Has the unit been Internally Verified?                                                                            Y/N

Date of verification:

Internal verifiers signature:
Internal verifiers assignment brief:
Due Dates
Issue Date 05/10/2013 Final Due date 25/01/14
Due Task- 1 26/10/2013 Presentation
Due Task- 2 16/11/2013
Due Task- 3 07/12/2013

Unit Outcomes

Outcome Evidence for the criteria to pass.       Feedback Assessors decision Internal verification.
Task – 1:

You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P1.1 and P1.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.

Task L 1. Understand databases and data

management systems

 

 

 

 P1.1-  analyse the key issues such as Integrity, Security, Recovery, Concurrency & Atomicity etc and application of databases within organizational environments such as Banking, Retail, HR, Education etc P 1.1

(P,M,D)

P 1.1

(P,M,D)

 P1.2- critically evaluate the features such as entity, attributes, primary key, foreign key etc and advantages of database management systems using relevant example and diagram. P 1.2

(P,M,D)

P 1.2

(P,M,D)

Summarized Feedback for Task 1 (reflecting 1.1 and 1.2 Pass merit and distinction.)
IV  comments towards

Task 1

 

TASK 2:

You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P2.1 and P2.2. The answers need to be reflected the ComputerChoice database solution given on the case study. Answers without application to an organization or without examples will be marked as Resubmission.

Task L 2. Understand database design

Techniques

P2.1- analyse a database developmental methodology such as SSADM and its phases feasibility study, requirement analysis, requirement specification, physical design etc. P 2.1

(P,M,D)

P 2.1

(P,M,D)

P2.2 – discuss entity-relationship modeling such as one-to-one, one-to-many and many-to-many relationship and normalization with 1st, 2nd and 3rd normalization to design database solution for Computer Choice. P 2.2

(P,M,D)

P 2.2

(P,M,D)

Summarized Feedback for Task 2 (reflecting 2.1 and 2.2 Pass merit and distinction.)
IV  comments towards

Task 2

TASK 3:

You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P3.1, P3.2, P3.3 and P3.4. The answers need to be reflected to the Computer Choice database solution given on the case study. Answers without application to an organization or without examples will be marked as Resubmission.

Task L 3. Be able to design, create and

document databases

 

 

 

P 3.1 – apply the database developmental cycle i.e. learners need to show the workings of different phases of database development methodology to develop database solution for the Computer Choice given data set. P 3.1

(P,M,D)

P 3.1

(P,M,D)

P3.2 – design a fully functional database (containing at least

four inter-relational tables) including user interface i.e. need to create tables, forms using MS-Access 2007 for the Computer Choice database solution and also require to provide class presentation on developed database solution.

P 3.2

(P,M,D)

P 3.2

(P,M,D)

P3.3  – evaluate the effectiveness of the database solution and

suggest methods of improvement i.e.to create queries and reports using MS-Access 2007 for the Computer Choice database solution to evaluate the effectiveness of the solution for the business with ways to improve the developed solution in future.

P 3.3

(P,M,D)

P 3.3

(P,M,D)

P3.4 – provide supporting user such as user manual and technical documentation such as DFD, ERD, Normalisation, table , forms, queries and reports etc screen shots. P 3.4

(P,M,D)

P 3.4

(P,M,D)

Summarized Feedback for Task 3 (reflecting 3.1, 3.2, 3.3 and 3.4 Pass merit and distinction.)
IV  comments towards

Task 3

Merit grades awarded M1

 

M2 M3 P1 P2 P3 P4
 Distinction grades awarded D1 D2 D3  

 

Resubmit :
Any other comments
Grade given by the tutor:

Pass                                            Merit                                                Distinction

Tutors Signature:                                                               Date:

IV Grading Check:                                    Comments if any:

Agree

Disagree                                                   Modify grade to

IV signature:                                              Date:

Student feedback:

Student signature:

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

 ASSIGNMENT

Task – 1:

You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P1.1 and P1.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.

P1. Understand databases and data management systems

P1.1-  analyse the key issues such as Integrity, Security, Recovery, Concurrency & Atomicity etc and application of databases within organizational environments such as Banking, Retail, HR, Education etc.

P1.2- critically evaluate the features such as entity, attributes, primary key, foreign key etc and advantages of database management systems using relevant example and diagram.

Case Study

ComputerChoice: 

Mr. Craig has graduate recently from university and is planning to start up a computer hardware store to sell computer and computer accessories.

Mr. Craig has named the company ComputerChoice. Mr. Craig after research into the industry understood that most of the clients will be people enthusiastic about assembling computer. If the company can sell the products at the right price, the customer will come back to purchase. Therefore it is important to maintain the details of the customers. There are plans for direct marketing, in which case the contact details of the customers are of utmost importance.

There are plans to recruit 6-9 staff members. The staff will be paid salary as well as for every sale that they make, they will earn commission. There for the sale information should include the staff details.

Mr. Craig has approached a number of suppliers and has got the price list from each of them. Different suppliers supply the same product at different price. So along with the product the supplier data should also be recorded. Products of similar configuration from different manufacturer also have different price. Some of the customers are very keen about certain manufacturer. So it would be helpful to record the manufacturer detail along with the product details.

Mr. Craig has approach you to help him run the business management. He understands the need of customer relationship management and stock management. The database to be developed should assist him to run a successful business.

 Using above Case Study, you must answer the following assessment criteria in Task 2 and Task 3:

TASK 2:

You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P2.1 and P2.2. The answers need to be reflected the ComputerChoice database solution given on the case study. Answers without application to an organization or without examples will be marked as Resubmission.

P2 Understand database design Techniques

P2.1- analyse a database developmental methodology such as SSADM and its phases feasibility study, requirement analysis, requirement specification, physical design etc.

P2.2 – discuss entity-relationship modeling such as one-to-one, one-to-many and many-to-many relationship and normalization with 1st, 2nd and 3rd normalization to design database solution for Computer Choice.

TASK 3:

You are required to carry out a research by using supportive materials like books, websites, etc., and give a feedback of the findings on P3.1, P3.2, P3.3 and P3.4. The answers need to be reflected to the Computer Choice database solution given on the case study. Answers without application to an organization or without examples will be marked as Resubmission.

P3 Be able to design, create and document databases

P 3.1 – apply the database developmental cycle i.e. learners need to show the workings of different phases of database development methodology to develop database solution for the Computer Choice given data set.

P3.2 – design a fully functional database (containing at least four inter-relational tables) including user interface i.e. need to create tables, forms using MS-Access 2007 for the Computer Choice

database solution and also require to provide class presentation on developed database solution.

P3.3  – evaluate the effectiveness of the database solution and suggest methods of improvement i.e.to create queries and reports using MS-Access 2007 for the Computer Choice database solution to evaluate the effectiveness of the solution for the business with ways to improve the developed solution in future.

P3.4 – provide supporting user such as user manual and technical documentation such as DFD, ERD, Normalisation, table , forms, queries and reports etc screen shots.

Assignment Guidelines: 

  • Use a standard report structure, Word-process the report and use Normal script of a proper font size 12.
  • Produce an academic report, detailing the above issues with a word limit of 4000 to 4500 words.
  • Complete the title page and sign the statement of authenticity.
  • The Assignment sheet should be attached in the front.
  • Submit the document in a folder in the form of a file as well as a soft copy on the submission date.
  • It should be uploaded on E-Learning platform before the deadline and submitted to ——– and sign the submission form of the college.
  • Assignments submitted after the deadline will not be accepted unless mitigating and may be entitled for a late fee.
  • Collusion and Plagiarism must be avoided.
  • Start each answer on a new page and pages should be numbered. Highlight each question clearly.
  • Include a Bibliography at the end of the assignment and use the Harvard referencing system.
  • All work should be comprehensively referenced and all sources must be fully acknowledged, such as books and journals, websites (include the date of visit), etc.
  • Try to give the page numbers, publishers’ details and the year of publication
  • In order to pass you need to address all the LO and Assessment Criterias.
  • In order to get a merit you need to address the characteristics of M1, M2,M3
  • In order to get a Distinction you need to address the characteristics of D1, D2 and D3. Use a common format for the questions, for example:
  • Introduction (analyze the question.)
  • Underpinning Knowledge (write about the relevant theory/points)
  • Applied knowledge(Data Analysis)
  • Conclusions and Recommendations (summarizing the whole scenario keeping in view pass, merit, distinction criteria.)

Student feedback form with the Assessment Grid indicating their pass, merit and distinction:

Name:                                                               Registration Number:

Unit 17: Database Design Concepts

Outcomes/criteria: Indicative characteristics Possible evidence Feedback
L 1. Understand databases and data management systems

L2. Understand database design techniques

L3. Be able to design, create and document databases

As per the assessment criteria specified for pass

Do

Do

 

 

Task 1

Task 2

Task 3

 

Merit Description:
M1. Identify and apply strategies to find appropriate solutions. . Relevant theories and techniques have been applied.
. Effective judgments have been made.
. Complex problems with more than one variable have been explored.
. An effective approach to study and research has been used.
M2. Select/ design and apply appropriate methods/ techniques. . A range of methods and techniques has been applied.
. A range of sources of information used.
. The selection of methods and techniques justified.
. Complex information/data have been synthesized and processed.
.Appropriate learning methods/ techniques applied.
 

M3. Present and communicate appropriate findings.

. Appropriate structure and approach has been used.
. Logical and coherent arguments have been presented
. Technical language accurately used.
. A range of methods of presentation has been used.
. Familiar and unfamiliar contexts have been used.
. It is appropriate for familiar and unfamiliar audiences.
Distinction Description:
D1. Use critical reflection to evaluate own work and justify valid conclusion. . Synthesis has been used to generate and justify valid conclusions
. The validity of results has been judged
. Self-criticism of approach has taken place.
. Evaluation has taken place using defined criteria
. Realistic improvements have been proposed against defined characteristics for success.
D2. Take responsibility for managing and organizing activities. Autonomy/independence demonstrated
Substantial activities/projects or investigations have been planned, managed and organized.
The unforeseen has been accommodated.
The importance of interdependence has been recognized.
D3. Demonstrate convergent, lateral and creative thinking Ideas generate and decisions taken  

 

 

 

 

 

 

 

Convergent and lateral thinking have been applied
Capacity for innovation and creative thought has been used.
Receptiveness to new ideas has demonstrated.
Unfamiliar contexts have been applied.

Btech HND Assignment Help Australia provide best quality assignment writing service in affordable prices and we are providing most flexible assignment writing according to Students need, so book your Assignment with us, Order Now

Leave a Reply

Your email address will not be published. Required fields are marked *

eighteen − thirteen =