Related questions
Concept explainers
2- Use Lucidchart to create a Crow’s Foot notation ERD to support the following business
operations:
a. 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
help her run her business.
b. 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.
c. Because 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 repair by more
than one customer. However, each repair is associated with only one customer. When a
customer brings in a device to be fixed, it is referred to as a repair request, or just
“repair,” for short. Each repair request is given a reference number, which is recorded in
the system along with the date of the request, and a description of the problem(s) that
the customer wants fixed. It is possible for a device to be brought to the shop for repair
many different times, and only devices that are brought in for repair are recorded in the
system. Each repair request is for the repair of one and only one device. If a customer
needs multiple devices fixed, then each device will require its own repair request.
d. There are a limited number of repair services that PEAR can perform. For each repair
service, there is a service ID number, description, and charge. “Charge” is how much the
customer is charged for the shop to perform the service, including any parts used. The
actual repair of a device is the performance of the services necessary to address the
problems described by the customer. Completing a repair request may require the
performance of many services. Each service can be performed many different times
during the repair of different devices, but each service will be performed only once
during a given repair request.
e. All repairs eventually require the performance of at least one service, but which services
will be required may not be known at the time the repair request is made. It is possible
for services to be available at PEAR but that have never been required in performing any
repair.
f. Some services involve only labor activities and no parts are required, but most services
require the replacement of one or more parts. The quantity of each part required in the
performance of each service should also be recorded. For each part, the part number,
part description, quantity in stock, and cost is recorded in the system. The cost indicated
is the amount that PEAR pays for the part. Some parts may be used in more than one
service, but each part is required for at least one service.
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 1 images
- Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product ABC is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. Also, each time the product is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C. The sample database contents are shown in Table P10.1.Given the preceding information, answer Questions a through e.a. How many database requests can you identify for an inventory update for both PRODUCT and PART?b. Using SQL, write each database request you identified in Step a.c. Write the complete transaction(s).d. Write the transaction log, using Table 10.1 as your template.e. Using the transaction log you created in Step d, trace its use in database recovery.arrow_forwardTropic Vibe Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer. • Each musician that records at Tropic Vibe has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone. • Each instrument used in songs recorded at Tropic Vibe has a unique identification number, a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, Bflat, E-flat). • Each album recorded on the Tropic Vibe label has a unique identification number, a title, a copyright date, a format (e.g., CD or MC), and an album identifier. • Each song recorded at Tropic Vibe has a title and an author. • Each musician may play several instruments, and a given instrument may be played by several musicians. • Each album has a number of songs on it, but no song may appear on more…arrow_forward2. The following relational schema form a university database which is implemented in a relational database: student (s_ID, s_name, semester, year) department(d_ID, d_name, floor) course (c_code, c_title, d_ID, credits) Write down the Relational Algebra for the following queries: a) Find your own name using your own registration number as the student ID. b) Show the ID and name of the department located at the floor number equals to the last digit of your own registration number. c) Find the codes and titles of the courses having credits more than 3 credits. d) Find the name of all students from your own semester and year.arrow_forward
- A small Hotel owner wish to computerized the management of hotel operations. You are asked to assist in the development of a database for the hotel. The database keeps data about ROOM, EMPLOYEE and FACILITY. From the discussion session with the hotel manager, you have identified the following information: • Three types of ROOMS offered by the hotel are single, double and deluxe room. Each room is identified by its unique number. • In general, there are two main types of the hotel jobs, GUEST SERVICES and ADMINISTRATIVE & SUPPORT. • HOTEL MANAGER, EVENT PLANNER and ACCOUNTANT are the administrative and support job positions in the hotel. • Types of employee falls under the guest services are RECEPTIONIST, HOUSEKEEPER, or KITCHEN STAFF. • Each RECEPTIONIST is identified with her/his name, employee number and years of experience. • The receptionists need to assign a HOUSEKEEPER to each room every morning or whenever it required before the room can be assigned to a guest to ensure…arrow_forwardUsing the Crow’s Foot Diagrram technique, draw a database design for the attached database.arrow_forwardCreate a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager…arrow_forward
- Create an ERD (Crow’s Foot notation) for the databasearrow_forwardA small Hotel owner wish to computerized the management of hotel operations. You are asked to assist in the development of a database for the hotel. The database keeps data about ROOM, EMPLOYEE and FACILITY. From the discussion session with the hotel manager, you have identified the following information: • Three types of ROOMS offered by the hotel are single, double and deluxe room. Each room is identified by its unique number. • In general, there are two main types of the hotel jobs, GUEST SERVICES and ADMINISTRATIVE & SUPPORT. • HOTEL MANAGER, EVENT PLANNER and ACCOUNTANT are the administrative and support job positions in the hotel. • Types of employee falls under the guest services are RECEPTIONIST, HOUSEKEEPER, or KITCHEN STAFF. • Each RECEPTIONIST is identified with her/his name, employee number and years of experience. • The receptionists need to assign a HOUSEKEEPER to each room every morning or whenever it required before the room can be assigned to a guest to ensure the…arrow_forwardGiven the following data structures definitions: istruct Record { string word; int occurrenceCount; int scoreTotal; }; istruct Database { Record records[CAPACITY]; int countWords; }3; Database db%; I want to write a line of code that prints out the first (index 0) character of the word in the second (index 1) record in the database variable db. Assume that the database db contains at least two records. In the statement below, what expression should I use in place of /*insert code here*/ to do this? cout << /*insert code here*/ << endl;arrow_forward
- Task 1:Create a database Entity and Relationship Diagram (ERD) for the following application:Please include answer with detailed explanationKhair Application: The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of…arrow_forwardPLZ help with the following: A nonprofit Canadian organization that provides aid to people after natural disasters needs your help to manage their data and to design a database for them using the following business rules: Individuals volunteer their time to carry out the tasks of the organization. Each volunteer may be assigned to several tasks during the time that they are doing volunteer work, and some tasks require many volunteers. It is possible for a volunteer to be in the system without having been assigned a task yet. It is possible to have tasks that no one has been assigned. When a volunteer is assigned to a task, the system should track the start time and end time of that assignment. The tasks of type “packing” result in the creation of packages. Each individual package of supplies that is produced by the organization is tracked. Each package is assigned an ID number. The date the package was created, and total weight of the package is recorded. A given package is associated…arrow_forwardCreate and upload a relational schema (using ERDPlus) for a database that covers the following rules: 1. Each student is advised by one faculty, and each faculty has many student advisees 2. Each faculty is affiliated with multiple departments, and a department have many faculty affiliates (note the change from class) 3. Each student is registered with many departments and each department has many registered students 4. Each department is chaired by one faculty, and any one faculty can chair only department 5. Each course is listed under one department 6. Each faculty can teach many course offerings, and each course offering can be taught by one faculty 7. Each student can take many course offerings, and each course offering will have many studentsarrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education