Get Cheapest Assignment in Australia, UK, US, UAE, Canada and NZ Order Now

Unit 4 Database Design and Development

0 Comments

LEARNING OUTCOMES Unit 4 Database Design and Development

By the end of this Unit, students will be able to:       

LO1Analyse the information requirements of organisations.

LO2 Discuss the types of information systems that are used within all levels of anorganisation.

LO3Demonstrate the use of an information system to produce management information.

LO4 Evaluate the effectiveness of strategic information systems.

Unit 4 Database design and development
Unit 4 Database design and development

ESSENTIAL CONTENT

LO1 Use an appropriate design tool to design a relational database system for a

substantial problem

The role of database systems e.g. as back-end systems, in e-commerce, for data mining applications etc.

Determining user and system requirements.

Design tools and techniques for a relational database system.

Logical design for relational databases e.g. tables, data elements, data types, indexes, primary/foreign keys, entity relationship modelling, referential integrity, data normalisation to third normal form.

Designs for data integrity, data validations, data security and data controls.User interface design.

Output designs for user requirements.

Overview of object-oriented databases and their design tools.

LO2 Develop a fully functional relational database system, based on an existing

system design

Consideration of database and platform options for system development.

Examination of different software development options for developing therelational database system.

Implementation of the physical data model based on the logical model.

Data stores, internal storage and external storage (e.g. the cloud).

Implementation of security elements in databases.

Relational databases with controls like data validation using; input masks, dropdown lists, option buttons.

User interface for requirements, functionality, reliability, consistency and

performance.

Consideration of interface links with other systems e.g. internet-based

applications. HND Assignment help UK

Data manipulation using appropriate query tools, including complex queries toquery across multiple tables, and using functions and formulae.

Database maintenance and data manipulation: inserts, updates, amendments,

deletions, data backup and recovery.

System reports using report writing tools and report generators, dashboards.

LO3 Test the system against user and system requirements

Identify elements of the system that need to be tested.

Consider data that should be used to fully test the system.

Match tests against user and system requirements.

Test procedures to be used: test plans, test models e.g. white box, black box; testing documentation.

Functional and system testing and testing the robustness of the system, including help menus, pop-ups, hot-spots, data validation checks.

LO4 Produce technical and user documentation

Technical and user documentation and their contents.

The documentation can include diagrams showing movement of data through the system, and flowcharts describing how the system works. Documentation could also extend to user guides and any initial design and implementation plans. Get Assignment help for Unit 4 Database design and development

Recommended Resources

Textbooks

Churcher, C. (2012) Beginning Database Design: From Novice to Professional.

2nd Ed. Apress.

Connolly, T. and Begg, C. (2014) Database Systems: A Practical Approach to Design,

Implementation and Management. 6th Ed. Global Edition. Pearson.

Kroemke, D. and Auer, D. (2012) Database Concepts: International Edition. 6th Ed.

Pearson.

Paulraj, P (2008). Database Design and Development: An Essential Guide for IT

Professional. Wiley.

Stephens, R. (2008) Beginning Database Design Solutions. Wrox.

Journals

International Journal of Database Management Systems

Journal of Database Management

The Computer Journal

Journal of Systems Analysis and Software Engineering

Journal of Emerging Trends in Computing and Information Sciences

Websites

www.lynda.com                      Database Training (Tutorials)

mva.microsoft.com                 Microsoft Virtual Academy “Database

                                                Development” (Training)

mva.microsoft.com/ebooks    Microsoft Virtual Academy

                                                “Microsoft Press” (E-Books)

Links

This unit links to the following related units:

Unit 7: Strategic Information Systems

Unit 38: Database Management Systems

Learning Outcomes and Assessment Criteria

Assessment Criteria
PassMeritDistinction
LO1:Use an appropriate design tool to design a relational database system for a substantial problem    D1Evaluate the effectiveness of the design in relation to user and system requirements.             LO2 & 3 D2Evaluate the effectiveness of the database solution in relation to user and system requirements, and suggest improvements.            
P1Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements.M1Produce a comprehensive design for a fully functional system which includes interface and output designs, data validations and data normalisation.
LO2:Develop a fully functional relational database system, based on an existing system design  
P2Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables.   P3Implement a query language into the relational database system.M2Implement a fully functional database system which includes system security and database maintenance.   M3 Assess whether meaningful data has been extracted through the use of query tools to produce appropriate management information.
LO3: Test the system against user and system requirements
P4Test the system against user and system requirements.    M4Assess the effectiveness of the testing, including an explanation of the choice of test data used.
LO4:Produce technical and user documentation    D3Evaluate the database in terms of improvements needed to ensure the continued effectiveness of the system.
P5Produce technical and user documentation.M5Produce technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works.

ASSIGNMENT BRIEFAND GUIDANCE

Unit Number and TitleUnit 4 Database Design and Development
Academic Year2021/2022
Unit TutorMohammad Rahman
Assignment TitleDesign a relational database system for an organisation
Assignment NumberAssignment 1 of 1
Issue Date20thSeptember2022
Submission Date12thDecember 2022
IV Name & DateOlu Akingbehin 16/09/2022
Submission Format
Your submission will include one assessmentto be submitted on Moodle/Turnitin as a word-processed document. The assessment will be in the form of an academic report, which will have a clear title page indicating the unit number, assignment title, the relevant activity being addressed, your name and student number.   You are expected to use external sources, and clearly reference these in your work. References should be added to the text (next to the quote or paraphrase), and also placed at the end in a references list, using Harvard Referencing style. The recommended word count for this activity is 1500 to 2000 words, but you will not be penalised for exceeding this.
Assignment Brief and Guidance
Assessment: An academic report (1500-2000) words Database design and development is an essential day-to-day requirement used by many organisations to ensure the follow of information is kept up to speed in order to meet the rapid growing e-commerce prospects.Modern is a fast-emerging organisation selling online laptops and intends to compete with other leading business such as, Dell and HP. The e-commerce industry is growing rapidly and Modern wants to expand its business in this sector. The issue is the current database has minimum capacityto manage online applications and registration, and therefore needs further developing.   Scenario   As a juniordatabase design and developer, your line manager has tasked you to design a database that will ensure robustness and security for Modern, and you will incorporate four-way relational database table to demonstrate design techniques and structured query language (see indicative content handout for more details).

PROPOSED OUTLINE OF PROGRAMME (subject to change)

Week 1 – Introduction to the Unit content and the Unit assessment,followed by anintroduction to database design and development.

Week 2 – Design and produce a comprehensive database system that is interrelated with at least four business units. 

Week 3– Access software will be utilised to design and develop database system showing querying across multiple tables.

Week 4 –Implement database system security and maintenance to meet user requirement.

Week 5 –Assess query tools into relational database to manage information appropriately.

Week 6–Reading week

Week 7 –Evaluate the design of databasein relation to the requirement and user interface.

Week 8 –Carryout test to ensure the database system is effective to meet user requirements.

Week 9 – Produce technical user document showing diagrams, data flow and flowcharts explaining how the database works.

Week 10 – Evaluate the database system to identify level of improvements needed for continued maintenance support.

Week 11 – Assignment workshop.