SQL QUESTION 3Requirements Specification (this is a fictional scenario)A fitness company stores the current assignments of trainers to customers in a document file like this:Trainer: Jones, William; phone 175-221-9988; hired in: 2019%3;• Customer: Garcia, Robert; phone 175-751-8822; year of birth: 1988;• Goal: building endurance;A trainer will usually have several customers with different goals, but may have no customers. As soon as it is registered, a customer is assigned to a single trainer. The customermay decide to change a trainer, but previous assignments are not kept. A trainer has at most 10 customers.There is no middle name stored with the trainers or customers. Both must have a phone number. For some trainers, the most recent hiring year is stored. For some clients the yearof birth is stored. All customers must have a goal specified.The first and last name have at most 21 characters each. The phone number will be stored with the following pattern: ppp-ppp-pppp. The hiring year and year of birth are numberswith 4 digits.One may want to search based on first name or last name, phone, goal, hiring year and year of birth.Data Entry Constraints for Task 4• The third trainer must have at least two customers in the data entered.• You must have two customers with the first name Sue.• At least two trainers must be hired after 2015 and two before.Database Questions for Task 5• For each assignment, list the first and last names for both the trainer and the customer. Use suggestive names for the columns in the result.• Pick the ID for the third trainer you defined in the database. List the full names (FIRST SPACE LAST) for all the customers of the selected trainer (in one column named"Customer").• List the full names (FIRST SPACE LAST)for the trainer and customers (in two columns named "Trainer" and "Customer"), for which the customer first name is "Sue"• List the names for the trainers in the format (LAST COMMA SPACE FIRST) hired after 2015 and the full names of their customers. Show the result in two columns named"Trainer" and "Customer".

Here are the geometric shapes and their meaning in an E-R Diagram. Rectangle: Represents Entity…

Answered: Requirements Specification (this is a…

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

Testa Inc. is a company specializing on self-driving electric vehicle (EV) production. In Testa, a self-driving EV is represented as a model, which is identified by its Model_No and has the attributes of Model_Desc (description), Production_Date, and Model_Cost. Each model uses one to many parts in its production; each part may be used in zero to many models. The number of parts (Num_Parts) is recorded for each part used in a model. Each part is identified by Part_No and has the attributes of Part_Name, Part_Cost, and Effective_Date. Each part may consist of zero to many other parts; each part may be a component of zero to many other parts. The nearby entity-relationship diagram shows the aforementioned situation. Testa is asking you to develop a MySQL database to manage its part and model data. You will create the tables and their data in your MySQL account and upload the MySQL script here. First, you are required to download a text file (click here) and then open it using a text…
Short answers: 1. Assume that there are 12 records in training data and there are three classes: C1, C2, and C3. Write down the number of records in each class so that the Gini index is maximum. C1: C2: C3:
Q3:Design UML for the following set of requirements for a universitydatabase that is used keep track of student’s transcripts.1. The university keeps track of each student’s name, student number,social security number, current address and phone, permanentaddress and phone birthdate, sex, major department, minordepartment (if any), and degree program (B.A., B.S., Ph.D.). Bothstudent number and social security number have unique values foreach student.2. Each department is described by a name, department code, officenumber office phone, Both name end code have unique values foreach department3. Courses are described by a course name, course number, credithours and department. each course has one or more prerequisitecourse.4. Each section has an instructor, semester (spring) , year , course ,and section number. The section number is unique.5. A grade report needs to be printed out to display the studentnumber, the section and the numeric grade
Exercise 1 Car Dealership Create an ERD for a car dealership. The dealership sells both new and used cars, and it operates a service facility. Base your design on the following business rules: A salesperson may sell many cars, but each car is sold by only one salesperson. A customer may buy many cars, but each car is bought by only one customer. A salesperson writes a single invoice for each car he or she sells. A customer gets an invoice for each car he or she buys. A customer may come in just to have his or her car serviced; that is, a customer need not buy a car to be classified as a customer. When a customer takes one or more cars in for repair or service, one service ticket is written for each car. The car dealership maintains a service history for each of the cars serviced. The service records are referenced by the car’s serial number. A car brought in for service can be worked on by many mechanics, and each mechanic may work on many cars. A car that is…
Registered user can book online for movie ticket. They can search for movies, select the appropriate time and data, and make payment. Admin is going to add new movies into database. Draw a class diagram for the scenario given by adding appropriate attributes and functions for each class. Show the relationship among classes with correct cardinality.
A corporation reimburses its employees in the managerial cadre and above for their mobile phone subscription costs. The information is captured in the record structure below. Employee Number is a three-digit numerical key that is designated as the primary key. type describes a pre-paid or post-paid class of mobile service subscription. The expenses incurred by the employee at the end of each month are referred to as subscription charges.Type of mobile number: employee number designation Subscription\schargesImplement the file asa) an array of records (block size = 1) for a sample set of records.b) an array of pointers to records (assume that each pointer to a record is a linkedlist of two nodes, each representing a record. In other words, each block is a linkedlist of two nodes (block size = 2)).
The following tables are part of a schema of an auto insurance company. The insurance database keeps a record of cars and a record of claims for cars where policy holders could have initiated an auto insurance claim such as an auto accident. Issues for which a claim is initiated are called claim events. All claims have a claim event. A type of a claim event could be found in one or more claims. A car could have no or many claims. Every car has a make and a model. One car make could have one or more models. Write a query that shows the make, model, VIN number and year of manufacture only for cars that have an auto insurance claim of any event type. If the database tables were populated, your query would not list cars that have not had a claim. You do not need to create the database to answer this question but you might just for visualization. CREATE TABLE CAR_MAKE (CAR_MAKE_ID INT NOT NULL PRIMARY KEY,CAR_MAKE VARCHAR(25)); CREATE TABLE MAKE_MODEL (MAKE_MODEL_ID INT NOT NULL PRIMARY…
DATABASE : Please draw an EERD based on following description. Suppose that you are asked to model the human resources in a university. They consider three types of people: employees, student and alumnus. Employee has SSN, name, address, gender, date of birth, salary, and date of hire. And there is no other type of personnel in this university. Some employees are also alumnus. And also, some students are also employees. Students have SSN, name, address, gender, date of birth, and major department. Alumni have SSN, name, address, gender, date of birth, degree, and degree received date. Employees can be partitioned into two sub types: faculty and staff. Faculty has the specific attribute rank, while staff has the specific attribute position. An employee cannot be both faculty and staff at the same time. Two subtypes are also defined for students: graduate student and undergraduate student. Undergraduate student has the attribute class_standing, while graduate student has the attribute…
Question 1: Create an ERD that can be implemented for a medical clinic, using at least the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor, and each appointment references a single patient. Emergency cases do not require an appointment. However, an emergency is entered into the appointment book as "unscheduled" for appointment management purposes. If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. Each visit updates the patient's records to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be…
Clayton Elementary School is converting the wish list request form below into online form because of COVID-19. 1. Class Diagram: Class name, attributes, and data type Operations (Methods) that you need to perform 'Fill Wishlist' Relationship between classes. Multiplicity of each relationship Assumptions that you need if any Sequence Diagram: Actor, boundary, and control objects Objects that participate this use case Messages, operations, etc. that indicate a successful filling of the form as illustrated in the form above.
A multinational company hired you to develop their employee management system. There are many employees working in different positions and departments. Make a structure for each department telling the number of employees in that department including the heads. Also each position has a reporting head defined in the chart given below also state the reporting head in the employee structure. Make a structure for all the employees holding their bio – data which includes: Name Employee ID CNIC Phone Number Age Department Position Add more necessary variables as required. Create functions to perform these operations: Add Employee Modify Employee Delete Employee Print All Employee Display Details of all Employees Search Employee using Position Search Employee using Department Search Employee using Employee id
A multinational company hired you to develop their employee management system. There are many employees working in different positions and departments. Make a structure for each department telling the number of employees in that department including the heads. Also each position has a reporting head defined in the chart given below also state the reporting head in the employee structure. Make a structure for all the employees holding their bio – data which includes: Name Employee ID CNIC Phone Number Age Department Position Add more necessary variables as required. Create functions to perform these operations: Add Employee Modify Employee Delete Employee Print All Employee Display Details of all Employees Search Employee using Position Search Employee using Department Search Employee using Employee id I want this program code in C language Please.

SEE MORE QUESTIONS

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS