Interpret entity relationship diagrams to implement database

Assignment Help Web Project
Reference no: EM133125329

ICT105 Data Modelling and Database Systems - Sydney International School of Technology & Commerce

Assessment - Database Design

Overview
The purpose of this assignment is to develop the student's skills in designing a relational database for a given case study.

Learning Outcome 1: Understand the fundamental concepts of relational databases, describe the different models of database management system.

Learning Outcome 2: Design a relational database for a provided scenario utilizing tools and techniques including ER diagrams, relation models and normalization.

Learning Outcome 3: Interpret entity relationship diagrams to implement database.

Assessment Details

Background

You have been appointed to create database for Toy community store. Toy community is an online store and has two types of inventories, toys and books. They would like database to manage their inventory, manufacturers, wholesalers, customer, and sales.

Some of the reports that Toy community store would like to run from your database design include a list of customers by city and a list of inventories by price or another category. They would also like to apply discounts to items by inventory type and apply discounts to VIP customers and to bulk orders. No normalisation has been undertaken on these entities, so there may be many to many relationships that are not resolved. Your submission should have all many to many relationships resolved. You may add entities or attributes as you see fit.

The minimum entities you are expected to have been listed below:

• Each inventory record will have a unique inventory ID, a title, a type (toys or books), retail price, number in stock, year, item code
• Suppliers will have their supplier ID, name, address, city, state, contact, product, TypeofGoods, paymentmethods
• Customers will have their customer ID, Name, Address, city, phone, email, Password, creditcard, billingaddress, shippingaddress, dateentered
• Wholesalers will have their name, address, contact, phone number, fax number, email address
• Orders will have orderID, customerID, paymentDate, orderDate, ShipDate, ShipperID

Requirements

Assignment should be presented in a report format including the following sections

1. Design your ER Diagram with all the entity names, attribute names, primary and foreign keys, relationships, cardinality, and participation indicated. You can add entities or attributes as you see fit. All many to many relationships must be resolved.

2. A discussion on normalization, the normal form that each entity is in, how normalization was achieved and why that is optimal.

3. A list of relationships with all table names, attributes, primary and foreign keys indicated as per the conventions given in the webinar slides (i.e., entity/table names in capitals, attributes as proper nouns, primary key underlined and foreign keys in italics).

4. A database schema indicating the type and purpose of all attributes.

A suggested structure for the report is given below: Titlepage

Table of Contents

Chapter 1. Introduction

Chapter 2. ER Diagram

Chapter 3. Relational Schema

Chapter 4. Normalization

Chapter 5. Conclusion

References

Attachment:- Database Design.rar

Reference no: EM133125329

Questions Cloud

Defense conversion can be diffi cult to undertake because : If a contractor is extremely risk averse, which sort of contract would be:
Valuing the benefits of environmental assets : What are the benefits of taking a whole-of-life approach to valuing the benefits of environmental assets?
Calculate the deferred tax liability and deferred tax asset : Calculate the deferred tax liability and deferred tax asset on 30 June 2022 and prepare the journal entry to record the deferred tax amounts
Reduce the rate of growth of money : During the economic expansion of the late 1990s, the Federal Reserve System took steps to reduce the rate of growth of money in the U.S. economy. Was this an ex
Interpret entity relationship diagrams to implement database : Understand the fundamental concepts of relational databases, describe the different models of database management system
How many copies of the software should i attempt to sell : Shaughnessy Consulting, LLC currently enjoys a patent on software that estimates economic damages for clients involved in personal injury lawsuits. Demand for m
Climate change and natural disasters for project package : A student from a previous semester chose the theme of Climate Change and Natural Disasters for his project package.
Patent and monopoly in software : Shaughnessy Consulting, LLC currently enjoys a patent on software that estimates economic damages for clients involved in personal injury lawsuits. Demand for m
Investing in the stock market : What are the potential positives and negatives that can come from investing in the stock market?

Reviews

Write a Review

Web Project Questions & Answers

  Evaluating an ecommerce website

Create a check list that contains key point for evaluating an ecommerce website - Write a short, reflective report about website

  Gpc and runtime magic quotes

Create a script that lets you know whether Zeus or Helios has the GPC and Runtime Magic Quotes turned on or off. The output should have appropriate labels that define what output signified and should display 'ON' or 'OFF' depending on the setting.

  Creating functions through conditional operator

Use the conditional operator and the cal_days_in_month function, determine the number of days in the current month and output to browser whether it is normal month or a leap month.

  Web development projects with database

Since the vast majority of web-development projects involve a database, do you think that computational activities should be performed there, or do you think they belong in the XML page or stylesheet?

  Comparing shelf software packages

Required assistance with comparing and contrasting two main off the shelf software packages that could be implemented in an organization.

  Web based scams

Web phishing, pharming and vishing are popular web based scams. Talk about currently used tools and recommended measures to defeat this kind of attacks efficiently?

  Explanation of contextual links

The most powerful hypertext capabilities is the the contextual link. Wikipedia . com is a great example of a site that utilizes contextual links.

  How architectural and protocol changes occur

Discuss how architectural and protocol changes happen, the administrative organization that oversees the technical development of the Internet,

  Traditional approaches for training professionals

Webinars and other web conferencing techniques have proved most beneficial for the provision of affordable quality corporate training.

  Internet for business

Discuss how can a business use the Internet and give at least three examples with web links demonstrating your answer.

  It influences the behavior of organizations

Information technology influences the behavior of organizations. Name one effect of Information technology implementation and long-term usage you suppose having a positive contribution and one having a negative consequence.

  Importance of a guided navigation system

Explain the use and importance of a guided navigation system and shopping cart for a website designed for e-commerce and business purpose.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd