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

Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements. There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design.
When constructing a database, an organization has to give careful consideration to the following aspects: the database's content, access, logical structure, and physical organization. Give further detail on each of these things.
Tutoring company wants to set up its database. They are trying to keep track of the following: student ID, name, grade level, the subject they need help in, and their contact and payment information. They also want to keep track of the tutors' information such as their ID, name, subject matter expertise, and times available and rate. They will like to keep track of which student is assigned to which tutor and their meeting schedule as well. 1. List all of the data that needs to be kept track of for the scenario above in a 1NF (Flat File) table 2. Use the normalization technique and form the 3NF tables 3. Write out the Create Table command in SQL for creating the database you have designed, make sure to use the right DATATYPES, CONSTRAINTS, and CONSTRAINT REFERENCES. Create Table **** 4. Write one SQL Insert into Values ; command for each table in your database
Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements. There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design.
options are correct or incorrect for 1-3 at the bottom
StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
E-R diagrams or DBDL may show database structure. Why do you prefer this method?
When constructing a database, the designer must know what types of relationships exist between records in different data sets, such as one- to-many or many-to-many. Give three examples for each of these relationships.
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…
Scripts and stored procedures are two different kinds of items that may be used in databases. How do their differences from one another manifest themselves? They each engage in a variety of activities. If you want to implement stored procedures, it is strongly recommended that you do it via the usage of a database rather than through any other method.
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…