2 You are asked to create a database to produce a report of customer details. The report is to list the customer name, account balance, credit limit and other customer details. The report will be also list the customer account rep (one of our sales employees). Our sales reps manage many customers each, but each customer will be managed by only one account rep at any one time. However, your design should allow for customer's being managed by many account reps as it is possible that some of our employees may leave the company- thus, requiring new account reps for a customer. List the entities, attributes and relationships among entities to be included in the ER model. Identify the cardinality of each relationships and Draw on ER diagram

2 You are asked to create a database to produce a report of customer details. The report is to list the customer name, account balance, credit limit and other customer details. The report will be also list the customer account rep (one of our sales employees). Our sales reps manage many customers each, but each customer will be managed by only one account rep at any one time. However, your design should allow for customer's being managed by many account reps as it is possible that some of our employees may leave the company- thus, requiring new account reps for a customer. List the entities, attributes and relationships among entities to be included in the ER model. Identify the cardinality of each relationships and Draw on ER diagram

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

Assume that you are the database developer for this task, complete the information-level design for the new database “Hostipal_Management” that satisfies the constraints and user view requirements given below. User view 1 requirement: The database should have information about Patients, Doctors, Appointments Bills and Payments. User view 2 requirements: Database system will store Patient’s details such as-Patient_ID, name, phone, email and home_address. Patients can make one or more appointments. However, one appointment is scheduled with only one patient. Patients can make several payments to the system, each payment belongs to only one patient. User view 3 requirements: Each doctor has an identification number and his/her name, telephone number, email and speciality should be recorded in the database. Examples for Doctor’s speciality - Cardiologist, Orthopaedics, Oncologists, Urologist, ..etc.(Note: It is a multi-valued attribute). User view 4 requirements: It is required to keep…
Your job as a database designer is to design a database with a schema that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, photograph, sculpture), and its price must be stored. Pieces of artwork also classified into groups of various kinds, for example, portraits, still lives, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group and property. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique ID, name, address, total amount of dollars spent in the gallery, and the artists and groups of art that the customer tends to like. Draw the ER diagram for the database.
When creating a database, here are the general steps that I follow: (a) determine the purpose of the reports I want to generate, (b) identify the format of the report, (c) ensure the data needed is available, (d) confirm the data is reliable. In some cases, the report format that I want to use is not available. Thus, I will work with my tech team to create the report. How can someone determine if the data is reliable? How can it be confirmed? Please discuss.
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…
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
Assume that you are hired to design a relational database to "manage" the thesis and the projects done in an academic department. Write a maximum 5 pages executive summary which will serve as the requirements analyses document. Your exec summary should provide the following information. No SQL implementation is required at this stage. Stake holders (not just the bare end users) End users Expected functionalities (i.e., sample queries in English, not in SQL) Relation/Tables with the attributes Primary key(s) for each table.
SportTech Events. SportTech Events SportTech Events puts on athletic events for local high school athletes. The company needs a database designed to keep track of the sponsor for the event and where the event is located. Each event needs a description, date, and cost. Separate costs are negotiated for each event. The company would also like to have a list of potential sponsors that includes each sponsor’s contact information, such as the name, phone number, and address. Each event will have a single sponsor, but a particular sponsor may sponsor more than one event. Each location will need an ID, a contact person, and a phone number. A particular event will use only one location, but a location may be used for multiple events. SportTech asks you to create a Conceptual Entity Relationship Diagram from the information described above.
1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.) 2. Design a database diagram for a database that stores information about the downloads that users make from a website. Each user must have an email address, first name, and last name. Each user can have one or more downloads. Each download must have a filename and download date/time. Each product can be related to one or more downloads. Each product must have a name.
T. Relational Model Instructions This assignment will show that you understand how columns should be separated between tables in a properly structured relational database. Your objective: Imagine you need to design a database that tracks members, type of membership, and exercise routines for each member. • Build a relational database model with multiple tables • Use your imagination and feel free to create the tables with as many columns as you would like. • Highest points will be awarded for completeness AND correctness. Submit as an Excel workbook or image.
Y3 In the team project you will essentially go through the stages of database development to solve an information need. It can be something in your work environment, for another organization, or a case that you make up. We will be using the Oracle Database management system (DBMS) for the projects. You will get additional information as the class progresses. The objective of this deliverable will be to notify stakeholders of the topic chosen for the group project. This deliverable will not be graded but it must be submitted and approved before you can proceed with the project. This is a brief (1-2 pages) document that must include the following information: Title of the project Project overview A brief statement, in common language, of the background and objectives of the project, including the problem you are attempting to solve or the opportunity for improvement that you hope to exploit. A description of a business situation:Describe briefly mission statement…
Create a Crow’s Foot notation ERD to support the following business operations: A friend of yours has opened Professional Electronics and Repairs (PEAR) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business.   When a customer brings a device to PEAR for repair, data must be recorded about the customer, the device, and the repair. The customer’s name, address, and a contact phone number must be recorded (if the customer has used the shop before, the information already in the system for the customer is verified as being current). For the device to be repaired, the type of device, model, and serial number are recorded (or verified if the device is already in the system). Only customers who have brought devices into PEAR for repair will be included in this system.   Since a customer might sell an older device to someone else who then brings the device to PEAR for repair, it is possible for a device to be brought in for…
Computer Science I need to create an SQLite database from a text file in QT that can hold a restaurant's name, how far it is from the other restaurants and its menu items with prices. The database should also be expandable. I'm unsure what to do and was wondering if someone could push me in the right direction or if anyone has any good resources to use.