Draw Entity Relationship Diagram for the proposed system

Assignment Help Database Management System
Reference no: EM132505545 , Length: 5 Pages

Assignment -

Case Study - An old school Ice cream shop that was quite popular in the neighborhood for many years, is suffering huge loss because of the opening of a nearby supermarket that hosts a variety of ice creams in their freezer section. The ice cream shop was once popular for their unique flavored ice creams but they are unable to predict the supply and demand causing many customers to get disappointed because they go out of stock every so often. The owner of the ice cream shop is your friend and asks you for advice to resolve this problem. Take him through the SDLC phases and present requirements, designs and a project plan for your proposed system to the owner.

1. a. Gather Requirements for the proposed system by using the Traditional and Modern methods. State which method(s) were used to gather requirements and enumerate the list of questions that you will ask.

1. b. Decompose the system into multiple subsystems/components and write requirements for each subsystem.

2. Draw Entity Relationship Diagram for the proposed system based on the requirements showing the Entities, Attributes and Cardinality between entities.

3. Draw Context and Level-0 Data Flow Diagrams for the proposed system based on the requirements.

4. Develop a list of phases for this project and Prepare a Gantt Chart showing the timeline for each phase.

Prepare a packet for your project with the following:

a. Title of your project

b. Table of Contents

c. List the Methods for gathering Requirements

d. System Decomposition and Requirements

e. Entity Relationship Diagram

f. Data Flow Diagrams

g. Project Plan with Gantt Chart

h. Conclusion (include any thoughts and learning)

Reference no: EM132505545

Questions Cloud

What are the challenges presented by the case : Human Resources, especially in global organizations, is challenged to be aware of the variations of law from country to country, not only to understand.
Explain what about the movement between dancers : Explain what about the movement, the interactions between dancers, the rhythms and speed, the costumes, the music led you to your conclusions
What are some of the challenges associated with segment : Read the Disney case study located in the textbook on page 184. Choose a segment of Disney that could include theme parks (both domestic and global).
What extent does story of ion justify and make look natural : What extent does the story of Ion justify and make look natural the actions and policies of the Athenians? Do you think Euripides supports those policies
Draw Entity Relationship Diagram for the proposed system : Draw Entity Relationship Diagram for the proposed system based on the requirements showing the Entities, Attributes and Cardinality between entities
Describe some of the work done by fema : Describe some of the public health implications of these disasters and FEMA's role in preventing controlling these situations. Were they effective?
Discuss important concept applicable to your work experience : Given the readings and assignments in the course, identify and discuss three important concepts applicable to your work experience, profession, and/or career.
Compare the mean and mode and median : Why are absolute numbers and percentages, when one is presented without the other, so often misleading? Compare the mean, mode, and median.
What can tell them about the audit to calm the fears : What can you tell them about the audit to calm their fears? Additionally, what can you as project manager do to make the audit proceed quickly and effectively?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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