Create a relational database to store

Assignment Help Database Management System

Reference no: EM133854459 , Length: word count:1000

Data Acquisition and Management

Assessment - ER Modeling and Normalizing Data

Task

Read the Assessment Instructions and complete sections (1) - (4)
Consider the rubric at the end of the assignment for guidance on structure and content.

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:
KBS Pty Ltd is a small business that sells products online. The company is expanding its operations 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 their data in one place, making it easier to manage and report on. Get Professional Assignment Help Service Now!

Assessment Instructions
You are required to complete the following tasks:
Design an entity-relationship model (ERM) for the database using Lucid Charts or any other ER Modeling tool, and include all required necessary tables, columns, and relationships.
Normalise the tables to 3rd normal form (3NF) using appropriate data normalisation techniques.
Create a report outlining your database design and data normalisation decisions.

Your report should be submitted as a Word Document and include the following sections:
Introduction: A brief overview of the business and the purpose of the database.
Entity-Relationship Model: A diagram and explanation of the ERM, including all tables, columns, and relationships using crow's feet notation.
Normalisation: An explanation of the normalisation techniques used and how the tables were normalised to 3NF.
Conclusion: A summary of your design decisions and any limitations of your database design.

Reference no: EM133854459

Questions Cloud

How healthcare issue-stressor may impact your work setting : Describe a national healthcare issue/stressor you selected for analysis, and explain how the healthcare issue/stressor may impact your work setting.

How the healthy people initiative could be used by you : Discuss how the Healthy People initiative could be used by you, as a nurse, to make a difference in the health and wellness of people in your area.

Describe the concept of e-patient and what it entails : Describe the concept of e-patient and what it entails?

What additional assessment data should the nurse obtain : What additional assessment data should the nurse obtain? What lab tests would you expect to be ordered and what would you expect those tests to show?

Create a relational database to store : ER Modeling and Normalizing Data Assessment - create a relational database to store information about their customers, products, orders, and payments

What is the major function of a erythrocyte : What is the major function of a erythrocyte?

Explain how antibodies and antigens differ : Explain how antibodies and antigens differ.

Discuss about technologies to facilitate communication : Technology in healthcare continues to advance. You have learned about technologies to facilitate communication, Clinical information Systems.

Why is healthcare a right and not a privilege : Why is healthcare a right, and not a privilege?

User Account

All Pages