Paper Rose is a firm that manufactures and sells greetingcards, wallpapers and accessories through its retail shops indifferent cities. Paper Rose is intending to develop a data-base of its stores through which the managing director Mr.Krishnakumar Rawat wants to track the sales, customers,and employees. You have been hired as a consultant todevelop the database for the firm. The discussion you hadwith the manager has provided you the following details:a. Information about each store like store number, loca-tion, space area of the store in square feet..b. A store may have many customersc. Customers place order through the store.d. Customer can also place order through web site.e. Orders may consist of one or more items.f. A customer may place many ordersg. The manager would like to trace the details about thecustomers name, address, city, state, pin code, tele-phone, fax, email, date of birth, and local language theyspeak.h. The Customer may maintain different accounts or maynot have any account. The manager likes to maintain theSureaccount number, balance, last payment date, last pay-ment amount, etc.i. The store may sell all the items or may only sell few items.j. All orders should be identified with order date, andcredit authorization status.k. Each item should be identified with item description,colour, size, pattern, type etc.1. An item can be composed of set of items like guest roomwall covering may consist of wall cover (item code 51)and borders (item code 52).m. Rose paper has employed more than 100 people in dif-ferent stores and the manager would like to have infor-mation about the employees like name, address, skill,hired date, designation, salary, skill etc.n. Each employee would work only in one store.o. Rose Paper extends certain benefits to the dependents ofemployees. Hence the manager also needs to record thename of the dependent, age and relationship with theemployee.With the above information available, draw an ERIIndicate if you are making any assumptions while drawithe ERD. Also draw a data model for the same.

the diagram is an given below :

Paper Rose is a firm that manufactures and cards, wallpapers and accessories through its retail shops in different cities. Paper Rose is intending to develop a data mase of its stores through which the managing director Mr Krishnakumar Rawat wants to track the sales, customers You have been hired as a consultant to

Paper Rose is a firm that manufactures and cards, wallpapers and accessories through its retail shops in different cities. Paper Rose is intending to develop a data mase of its stores through which the managing director Mr Krishnakumar Rawat wants to track the sales, customers You have been hired as a consultant to

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Why is it beneficial to store data on the cloud? Which models are available, and what are the specific constraints that come with each option? Do you think it would be beneficial to give examples of other organizations that offer solutions via the cloud?
In today's business world, "big data" describes a feature of any company's IT infrastructure. What are the benefits and drawbacks of using it in one's professional life?
The need for a prototype for your data warehouse installation will be decided by that team. The launch of the enterprise-wide data warehouse has been postponed due to team members' worries about their level of data warehousing education. I've been thinking. Defend your position.
Urban data design is a company which designs digital products and concepts that make neighborhoods more sustainable and healthier place to live and do business in. This project focuses on a creation of a new app for Urban Data Design for one of their business problems. The app will make it easier for organizers to find the best suited open spaces according to their requirements for a potential event. Make it easier for everyday citizens to find and participate in interesting events happening in open spaces around them. The purpose is to provide a platform for people in the community to get information regarding open spaces located in their area. The people will be able to organize events in these open spaces and list them on the app. People can get information regarding events which are happening in their areas in open spaces. Provide the community to participate in communal activities to build strong ties and belonging to its community. These events can promote physical activities…
How Does NoSQL relate to big data?
The decision of whether or not to prototype a data warehouse prior to putting it into operation is on the data warehousing project group that you have. The members of the project group are especially concerned about the issue of obtaining skills in data warehousing prior to commencing on the installation of the enterprise-wide data warehouse. You are aware of what I am contemplating. Give specifics about your ideas.
Numerous data centers have adopted cloud computing architectures like Big Data Cluster. In minutes, we can set up a Big Data Cluster with the right amount of nodes. What's good about cloud-based Big Data?
What is KDD ? How it is different from data mining ?
The infrastructure of Big Data Cluster has grown completely reliant on cloud computing. We could set up a huge data cluster with the required number of nodes in a matter of minutes. Tell me about the benefits and drawbacks of using Big Data on the cloud.
How can relying on separate data silos lead to problems that cause you stress and worry?
Whom and how does relying on separate data silos present difficulties?
Many major corporations rely on electronic data exchange (EDI) to connect with their most important customers and vendors. What are the advantages and disadvantages of using EDI in business? Explain one manner in which the usage of electronic data interchange (EDI) impacts internal controls and the auditor's testing?