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

FeastFam is a restaurant group which consists of multiple restaurants nationwide. Due to recent restrictions imposed by the government, the group has had to adapt to a new way of managing information in their daily operations. FeastFam has approached you to help them with the creation of a database which will keep track of the following information: • FeastFam franchise group has a main headquarter office. The address of this office should be stored in the database. • FeastFam has many restaurants across South Africa (indicated using a “has-a" relationship). • Each restaurant has a name, location and phone number. To handle reservations the following needs to be considered: • Each restaurant can have many customers make reservations. • Each customer can have many restaurants at which they make reservations. • Each customer has a name, surname and contact number. • For each reservation the following information is stored: Date, time, number of guests. When the customer arrives with…
Gregory Adam owns multiple theatres across South Africa. As a lover af the performing arts, who would like to see the arts sector blossom, he has asked you to help him to develop a database for theatre management. The following information has been provided to you. The data that must be stored for each theatre include the theatre's name, city and the capacity (Le. how many people can be seated in the theatre). Each theatre has many artists working at the theatre and each artist works at only one theatre. There are three different types of artists that Gregory wishes to keep track of, namely, Musicians, Dancers and Actors. The attributes that all artists have in common are: Name and Surname. Each artist must be either a Musician, Dancer or Actor but cannot be any of them at once. Musicians have the instrument and genre in which they specialise. Dancers have a specific style they major in and the database should also keep track of their height. The database should, furthermore, keep…
You have been hired as an intern at the local community center. The center has a number of sports programs for youth. You have been asked to create a database to keep track of the programs and the youths who participate in these sports activities. The Community Center database must support the following requirements:i. For an activity, store its number and name, for example, 051, Track. Each activity has a cost associated with it.ii. For a participant, store his or her number, first name, and last name as well as the name, home telephone number, and cell telephone number of the parent or guardian primarily responsible for the participants.iii. One participant can enroll in many activities, and one activity can include many participants. One parent/guardian can have many participants.Based on these requirements:1. Identify and list the entities and attributes of those entities. 2. Identify and list the functional dependencies. 3. Without creating a set of dependency diagrams, write the…
Warner and his brothers operate a cinema chain (Warner and Brothers Movies). He wants to build a database to use for forecasting demand for both the movies he shows and the food he sells as well as to track other critical information for his business. He tells you he has several cinemas and each cinema has between 1 and 15 theaters. Each cinema has a location (address), a unique name and a phone number. The theaters vary in terms of seating style, type of sound equipment and seating capacity. Movies are shown throughout the day starting at 11 am and finishing at 1 am. Some movies will the shown in multiple theaters and over time may switch theatres that they show in. For instance, Star Wars may originally be shown in the 3 largest theatres in a cinema but after 3 months it may be showing in just one of the smaller theaters. Of course, each theater is also used for a variety of movies over time. Warner is interested in knowing how many people, classified by adults and children, attend…
A new veterinary clinic will like to set up their database. The clinic will like to keep record of their customers such as: pet name, pet type, pet age, pet weight, owner name, owner address, owner contact. Also the clinic will like to keep track of the veterinarian name, specialty and schedule. They will like to keep track of the customer appointment date, what the appointment is for, and how much it will cost. Question 1: List all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table Question 2: Use the normalization technique and form the 3NF tables
create ERD need help ASAP outline: relationship, connectivity, cardinality and keys, using crow-foot notation. You are a senior database architect and Alphine Hospital group has hired you to create a state of art database for their day-to-day functioning. You are given a process document with details function of the hospital. Hospital has two departments namely, in-patient department (IPD) and out-patient department (OPD). Both IPD and OPD patients require registration. Upon registration, personal details of the patients are collected, and they are referred to IPD section of the hospital. Depending upon the care and treatment required by the patient they can be treated in IPD, if hospitalization is not required. Otherwise, they are admitted to OPD section. IPDs and OPDs are divided into specialties and wards respectively. IPDs specialties include - Surgery, Neurology, Pediatrics, Internal Medicine, to name a few. OPDs are divided into wards - General, Special, ICU. ICU can be further…
GoBook GoBook is a books store located in London. The owner wants to manage easily and record all activities that belongs to GoBook like selling books to customer and purchasing new book from vendor. To improve GoBook’s management, The owner hired you as a database administrator are required to analyze and design a database for Bob’s shop using SQL Server Management Studio and and create an ERD database. Every staff that hired by GoBook have a task to serve a customer who wants to buy a book and purchase book from vendor. Every staff must be following the procedures to become a staff, which are: Every staff hired must have a personal information like name, gender, date of birth, address, email, phone number, and salary. Staff can purchase book(s) from vendor to restock the book stock. Every purchase transaction made with the vendor have all the information about staff, vendor, purchase date, book(s) purchased, and the quantity of each book. Every vendor that…
The Plaza is an apartment rental company that would like to create an online management system to keep track of apartment complex units, tenants, maintenance requests, and rental payment information. Since you are taking a database class, you are asked to assist the company in designing a database based on the following specifications. Each apartment unit has a unique number.Each unit's street number,street name, city, state zip code, number of bedrooms, monthly rent, and occupancy status are recorded. Each tenant must lease at least one apartment unit for a period of time. It is important to document the lease start date and end date. The Plaza tracks each tenant's name, SSN, home mailing address, and phone number. Each tenant is assigned a unique identifier number. Each tenant should pay the monthly rental fee by the first day of each month.Any rent due not paid by the 4th day of the monthly rental period is subject to a $50.00 late fee charge with an additional $10.00 for…
GoBook GoBook is a books store located in London. The owner wants to manage easily and record all activities that belongs to GoBook like selling books to customer and purchasing new book from vendor. To improve GoBook’s management, The owner hired you as a database administrator are required to analyze and design a database for Bob’s shop using SQL Server Management Studio and and create an ERD database. Every staff that hired by GoBook have a task to serve a customer who wants to buy a book and purchase book from vendor. Every staff must be following the procedures to become a staff, which are: Every staff hired must have a personal information like name, gender, date of birth, address, email, phone number, and salary. Staff can purchase book(s) from vendor to restock the book stock. Every purchase transaction made with the vendor have all the information about staff, vendor, purchase date, book(s) purchased, and the quantity of each book. Every vendor that…
The Super Coach Bus Company Sdn Bhd (SCBC) wants to develop a database to keep all information about its buses. Each bus bought by SCBC will be registered in the database. The information stored is bus plate number, model, year made, date of purchase and amount purchase. These buses are used to carry passenger from SNB bus station to many destinations all over Malaysia. Each bus may visit different destinations. Each destination can be visited by more than one bus. The information about destination includes destination code, destination name, and state. Once in a month, the buses need to be sent for maintenance to check for their conditions. The information about maintenance is maintenance identification, date sent for maintenance, date finish and the latest status of the bus condition. Every maintenance is performed by a mechanic. The information about mechanic that needed to be stored in the database is mechanic identification number and name. Other information about mechanic is…
You receive the following requirements for a caterer's database: For a customer, store a customer ID, last name, first name, billing address, and phone number For an order, store an order number, order date, event date, customer ID, description of services, and total price for services When designing this database, which step do you take first? a. Identify the customer ID and order number as unique identifiers. b. Identify and name the entities CUSTOMER and ORDER c. Identify customer ID, last name, first name, billing address, and phone number as attributes d. Create a CUSTOMER table that includes all the customers' attributes as columns
You handle administrative support for CyberToys, a small chain that sells computer hardware and software and specializes in personal service. The company has four stores located at malls and is planning more. Each store has a manager, a technician, and between one and four sales reps. Bruce and Marcia Berns, the owners, want to create a personnel records database, and they asked you to review a table that Marcia designed. She suggested fields for store number, location, store telephone, manager name, and manager home telephone. She also wants fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones. Draw Marcia’s suggested design and analyze it using the normalization concepts you learned in the chapter. What do you think of Marcia’s design and why? What would you propose?