Create a Crow's Foot notation ERD to support the following business operations:Create a Crowsfoot notation ERD to support the following business operations: -A friend of yours has opened Marshfield Electronics and Repairs (MER) 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 MER for repair, data must be recorded about the customer, thedevice, and the repair (also referred to as repair request). Completing each repair request can involvemultiple services (e.g. glass replacement, battery replacement, cleaning. Some services require parts.The customer's name, address, and a contact phone number must be recorded.For the device to be repaired, the type of device, model, and serial number are recorded (or verified ifthe device is already in the system).Each repair request is given a reference number, which is recorded in the system along with the dateof the request, and a description of the problem(s) that the customer wants fixed.For each Service, there is a service ID number, description, and charge (amount charged for theservice)Part number, Part description and Price are stored for each part.Each repair request is associated with only one customer. A customer may submit multiple repairrequests.Each repair request is for the repair of one and only one device. It is possible for a device to bebrought to the shop for repair many different times,Completing a repair request may require the performance of many services. Each service can beperformed many different times over multiple repairs, but each service is only performed onceduring the repair of a device.Each service may or may not require parts. A service may require many parts. A part is used in oneor many services. It is also possible that a part is not used in any service.

Crow's foot diagrams can be defined as the one which represents entities as boxes, and relationships…

Create a Crowsfoot notation ERD to support the following business operations: - A friend of yours has opened Marshfield Electronics and Repairs (MER) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business.

Create a Crowsfoot notation ERD to support the following business operations: - A friend of yours has opened Marshfield Electronics and Repairs (MER) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business.

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

Make your own relation instance(s)○ Determine a schema○ Write a CREATE command for the instance(s)○ Choose another SQL command that modifies the relation and write it in full
Make the following tables database:
Consignment shops offer a great service to our communities in that they allow us to purchase slightly used goods at very valuable prices. The original owners of these goods bring in their merchandise to selI. Upon selling the item, the consignment shop retains 25% of the sale for their services. You are working for a local shop. Every month the database, containing the sales data produces a report that details the amount sales per each original owner. Your job is to write a program that will help analyze this data. The array of sales data is as follows: owner sales = [201.45, 550.00, 117.65, 55.25, 5.95, 365.451 Your program needs to create 4 functions accomplishing the following tasks: main: This function will call all of your other functions, in the following order: Print Sales, Find Lowest and Determine Payout. It will also print the lowest sales. Print Sales: This function will print each sale. • Find Lowest: This function will find the lowest sale and print it. Determine Payout:…
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 unique Key Index
A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (eg animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner of the painting is…
You are asked to design a database for an auto insurance company Green Angel that satisfies the following requirements: a. Green Angel has several local offices. Each local office has a unique number, a unique name, an address, and a telephone number. A specific employee who manages the local office. b. The employee record includes social security number, name, address, phone number, date of birth, sex, and salary. Every employee works for a local office. c. Green Angel has several insurance plans. Each plan has a unique code, a fixed premium, a set of criteria for the people who are eligible for the plan. The set of criteria include age range, sex, and the state of residence. d. A subscriber has a unique subscriber's number, name, date of birth, sex, address, telephone number, insurance plan and the employee that handles the subscriber's paper work. Some queries access the records by the last name of the subscriber. Some queries need to refer to the zip code in the address. e. Each…
Page - 1 DBMS - TASK 1: Draw an ERD and Map it to relational schema. Please complete reading page 1 before going to page 2. In this task, you will be given a text that describes a company (in page 2). Each student should complete the steps below to fully solve the task Represent the company description as an ER-diagram, including all relevant constraints as the following steps: - Each student should download Lucidchart app Every student should use Lucidchart to draw the ERD Edit Lucidchart Blank diagram Select View Insert Arrange Help 80 What's New Saved Start a free trial to access unlimited shapes and documents! X BIUAT- 2 px None None 408 Liberation Sans ▾ 10 pt + Shapes O Standard × T Flowchart 000 ☐ ODOT ☐ ☐ ☐ ☐ ☐☐ )>0 × TU Xx 14 << ΔΟ ▼ Shapes ΠΑ ☐ ☐ Name B Present MA when you create After each entity ID print screen, your name include your user ID should be shown university ID number Department 0190334 Dep_ID Employee 0190334 Name
John liked your work so much that he would like you to create a database for the comic book shop that you worked with in the first project. Create a relational database with at least two tables. Comic book and company would be two logical ones
A local businesswoman has decided to start her own Internet business, called Masterpieces Ltd, hiring paintings to private individuals and commercial companies. Because of your reputation as a database designer she has called upon your services to design and implement a database to support her new business. At the initial planning meeting, to discuss the design, the following user requirements were requested. The system must be able to manage the details of customers, paintings and those paintings currently on hire to customers. Customers are categorized as B (bronze), S (silver), G (gold) or P (platinum). These categories entitle a customer to a discount of 0%, 5%, 10% or 15% respectively. Customers often request paintings by a particular artist or theme (e.g. animal, landscape, seascape, naval, still‐life, etc). Over time a customer may hire the same painting more than once. Each painting is allocated a customer monthly rental price defined by the owner. The owner of the painting…
10