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

Related questions

Q: Tasks: Considering the following E-R diagram, you need to translate it into a relational database…

A: An Entity-Relationship (ER) diagram is a visual representation of the entities (objects),…

Q: Please written by computer source 1. Let's say you're a database designer for a logistics company.…

A: To design a database for the logistics company, we can create the following entity-relationship…

Q: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track…

A: The most important step for drawing an ERD diagram is to identify the entities in the database. The…

Q: “Supporting a travel agency, TORS maintains tour information and provides reservation facilities for…

A: Here we have given specifications in the fully dressed form for the use case diagram. you can find…

Q: View 2 Seneca Courses Inc. Product Spreadsheet All the course books are maintained on the…

A: Actually, the answer has given below:

Q: “Supporting a travel agency, TORS maintains tour information and provides reservation facilities for…

A: The sequence diagram or system sequence diagram(SSD) shows the process interactions arranged in time…

Q: What you need to do: 1. Create an ERD for this database that you use as the basis of your…

A: Introduction Data Dictionary: A data dictionary is a tabular format representation of data model…

Q: Case Problem 1 The administrators of Tiny College are so pleased with your design and implementation…

A: For their motor vehicle pool, the Tiny College administrators manage the database. The following…

Q: Please follow the picture for answer these question! Vis Library is a multi-categories book library…

A: “Since you have posted a question with multiple sub-parts, we will solve first three subparts for…

Q: Supporting a travel agency, TORS maintains tour information and provides reservation facilities for…

A: The correct answer for the above question is given in the following steps for your reference.

Q: ere in this question how can i check room availability just clicking the button

A: A: You can use AJAX to achieve this.Here is an example:<code>$(function() {…

Q: As a stage of designing the Semuarasa restaurant database, some entity information and documents are…

A: Normalization:⦁ Food_Menu Table: 1NF (First Normal Form) Rules are as follows:⦁ Each…

Q: A new veterinary clinic will like to set up their database. The clinic will like to keep record of…

A: For creating tables in 1NF or 1st Normal Form, following properties must be satisfied: There must…

Q: Design a database that keeps track of projects and managers. You need to maintain information on the…

A: Database for projects and managers:

Q: In your new role as Database Developer, you'll get to decide whether to make use of a trigger or a…

A: Triggers are unique stored procedures in databases that execute automatically when a database server…

Q: he administrators of Tiny College are so pleased with your design and implementation of their…

A: The administrators of Tiny College maintain the database for their motor vehicle pool. The following…

Q: Topic: Database Choose a database recovery problem and then propose a solution using the its…

Q: Given the following scenario create an ERD for the Bookstore. I sell books and would like to create…

A: Bookstore ERDEntities:Book:Attributes:BookId (PK)TitleAuthorId (FK)PublisherId (FK)GenreId…

Q: oan Yancey has been asked to create a database for her company, Yancey Shipping. The database is to…

A: (Table 1) Employee Information:Fields - Last Name, First Name, Street Address, City, State, Zip…

Question

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

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

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.
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.
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…
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.
“Supporting a travel agency, TORS maintains tour information and provides reservation facilities for the people who wish to travel on tours via the Internet. The system allows users to view information about the tours available and make a reservation on a tour without asking the employees at the agency. Using the system, a user can cancel an existing reservation that the user made. The system also allows the user to send feedbacks by e-mail to the agency andstores the feedback in the database. Finally, the system allows the employees of the agency to manage customer information and tours such as adding, deleting, and updating information on customers and tours. For security purposes, the employees are required to provide login credentials (ID and password) to access the system.” Draw two system sequence diagrams, one for the success scenario of each use case. (Note : Please give me the sequence diagram for the above question)