TEC104 Database Design and Management

Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Assessment 1 Information

Subject Code:

TEC104

Subject Name:

Database Design and Management

Assessment Title:

Case Study

Assessment Type:

Individual

Word Count:                    1,000            Words                             (+/-10%)

Weighting:

20 %

Total Marks:

20

Submission:

MyKBS

Due Date:

Week 5

Your Task

This assessment is to be completed individually. In this assessment, you will design a relational database for a fictional small business, incorporating the following entities: customers, products, orders, and payments.

Assessment Description

You have been hired as a database designer by a small business that sells products online. The business wants to create a relational database to store information about their customers, products, orders, and payments. They want to be able to view sales data, customer information, and inventory levels.

Case Study:

ABC Pty Ltd is a small business that sells products online. The company is expanding and is looking to improve their data management systems. They currently have a system that stores customer information, product information, and order information in separate files, which has become difficult to manage as the business grows. They want to create a relational database to store all of their data in one place, making it easier to manage and report on.

This assessment aims to achieve the following subject learning outcomes: 

LO1

Explain Relational Database Management Systems and their application within organisations.

Assessment Instructions

.   You are required to complete the following tasks:

1.  Design an entity-relationship model (ERM) for the database, including all necessary tables, columns, and relationships.

2.  Normalise the tables to 3rd normal form (3NF) using appropriate data normalisation techniques.

3.  Populate the database with sample data.

4.  Write SQL queries to retrieve specific information from the database, such as customer details and sales data.

5.  Create a report outlining your database design and data normalisation decisions, as well as your SQL queries and the results of your data retrievals.

.   Your report should be submitted in Word Document or PDF format and include the following sections:

1.  Introduction: A brief overview of the business and the purpose of the database.

2.  Entity-Relationship Model: A diagram and explanation of the ERM, including all tables, columns, and relationships.

3.  Normalisation: An explanation of the normalisation techniques used and how the tables were normalised to 3NF.

4.  Data Population: Sample data for each table in the database.

5.  SQL Queries: At least three SQL queries demonstrating your ability to retrieve specific information from the database.

6.  Conclusion: A summary of your design decisions and any limitations of your database design.

.   Please refer to the assessment marking guide to assist you in completing all the assessment criteria.



2024-04-05