Customer Equipment equipment Code Loan id name id name equipment Code e startDate returnDate H description RentalRatePerDay address contact dateofBirth occupation DamageReport reportId damageType (iii) Create a view named CustomerSummary with details of each customer, the number of equipment rented, the total amount of rental collected thus far and the number of damages caused by customer and not due to wear and tear. LEIE Name Address Contact DateOfBirth Occupation Number of Equipment Rented Total Rert NumDamage F32J Cherles Toles S8 3F Damien Low sa56F Audrey Ng S45G Betsey Tan 99 34J Peter Lee s ATSZ Ali Bin Mohd Hassan 10 Clomons Road 91239123 10-07-1997 IT Programmor 0 S7 23 Haig Road 92142331 15-03-1976 Teacher 20.00 5 Still Rond 2 88128833 05-07-1985 Teacher 16.00 10 Bedok Road 82138213 23-01-1988 Nurse 3 150.00 1 4 2 Jalan Eunos 98981212 12-05-1990 Cartoorist 2 4.00 8 Jalan Melayu 97589758 04-03-1991 Student 24.00 0.00 7 575J Ravi SIO Ramasamy 12 Jurong Road 82223333 12-08-1998 Personal Trainer 0 0.00 (iv) Use the CustomerSummary view to find the average rental per loan for the customer with the most number of loans. Do not hardcode any value and do not assume that the loan table is non-empty or that there is one row of result as in general, there may be more than one customers with the most number of loans. name contact Number of Equipment Rented Total Rent Average Rental for biggest customer NumDamage 1 Audrey Ng 82138213 3 150.00 50.00

Q: What type of situation would you need to create or replace a view?     The view's underlying data…

A: Solution:   Given,   What type of situation would you need to create or replace a view?…

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Triggers? Why do they exist? How can I use the trigger features in Access 2016?

A: Triggers be database-specific technical codes that sprint if an exact condition is met for a…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Normalize the following form into UNF 1NF, 2NF and 3NF. Show primary keys and foreign keys for all…

A: We have given a table and we need to normalize the given table into 1NF, 2NF, and 3NF. Then we need…

Q: What is the primary key of the WorkHours table? Indicate the redundant field in the Employees table.

A: This question comes from Database Management System which is a paper of Computer Science. Let's…

Q: Creating factory Database SUPPLIER CUSTOMER Id ld CompanyName FirstName ContactName LastName City…

A: How to Add a New Column with ALTER TABLE To add a new column, you first need to select the table…

Q: 35. Key to represent relationship between tables is called a. Primary key b. Secondary Key c.…

A: Please find the answer to the above question below:

Q: Create a VIEW named ITEM_INVOICE. It consists of the item ID, description, price, invoice number,…

A: Here have to determine about the Create a VIEW named ITEM_INVOICE  programming problem statement.

Q: your submission will be the query that you would write that would return the needed result How many…

A: Below is the complete solution with explanation in detail for the given question about queries based…

Q: ITEM (ITEM ID, DESCRIPTION, ON HAND, CATEGORY, LOCATION, PRICE, NUM, INVOICE _ DATE, CUST PRICE))…

A:

Q: access databases Normalization Exercise Represent this table as a collection of tables in 3NF:…

A: The key for the given relation is (StudentNumber, CourseNumber)  The partial functional dependency…

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: DELETE CASCADE: - When we constitute a foreign key using this option, it deletes the referencing…

Q: repare the loan amortization table/schedule from scratch (not the Excel template) for a $300,000,…

A: Please refer the table we have calculated the loan value as 520000 = 650000*(1-0.80) as 20% is down…

Q: 9. Create a new table lab_instructor which has the ID, name, lab_incharge and experience attributes.…

A: -- QUERY TO CREATE TABLE : CREATE TABLE lab_instructor( ID int primary key, name varchar(50),…

Q: Database Management Systmem create a Sql table and do the following operations insert upsdate…

A: create table tblShippers(  2  ShipperID number(10) primary key,  3  CompanyName varchar2(50)  4  );…

Q: Please draw an EERD based on following description: A rental car agency classifies the vehicles it…

A: Entity Relationship Diagrams (ER diagrams) are flowcharts that show all of the relationships between…

Q: a COVID-19 management system. Assume you have normalized the raw data into the 3d Normal Form. Below…

A: Given data contains four tables Patient, Quarantine centre, nurse and admission.  Each table…

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: List the complete location table (all rows and all columns).

A: Query select * from Location, Explanation:   select clause is used to retrieve data from specified…

Q: Create a new table named PRODUCT. The product table will have two attributes;  product ID as…

A: Create a new table named PRODUCT. The PRODUCT table has two attributes: A product ID as an integer…

Q: Create a view  named mobile_sales_details which has the following attributes. Display the sales id,…

A: We need to create a view in SQL named mobile_sales_details. This view displays the sales id, sales…

Q: Create a new table named ScheduledClients to contain client’s name, the scheduled date of service,…

A: CREATE TABLE ScheduledClients AS SELECT c.ClientName AS ClientName, o.ScheduledDate AS…

Q: Which one of the following attribute (set) should be candidate key? ( ) Student ID number, First…

A: In the context of database design, selecting the appropriate candidate key is crucial to ensure data…

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

A: Queries are given below :

Q: FirstName EID Name LastName Employee Birthdate TEL n Age work date ID m Name Project Rate In the…

A: SQL (Structured Query Language) is a popular language for accessing and manipulating databases. It…

Q: Using the schema below write the DDL code to create the customer and order table in the  new…

A: The SQL queries for the DDL and DML commands are provided below.DDL stands for Data Definition…

Q: Using the Winners table from Figure 12-2, write a parameter query that selects theActor and Actress…

A: A query that has a parameter marker instead of a value of criteria is called as parameter query. The…

Q: Use the query box below to answer the questions, saving your query for each question. When you are…

A: The above question is solved in step 2 :-

Q: Show the list of courses numbers that are taken at least once by students. The course should appear…

A: So, all the unique course numbers has to be printed So, for this you can make use of DISTINCT…

Q: After converting the ERD to a table design, what fields will be present in the Contracts table?…

A: An Entity-Relationship (ER) diagram is a visual representation of the data model that represents the…

Q: Task 10 Task 10: List all the tables contained within the system catalog, but only display the…

A: Task 10: SELECT * FROM (SELECT table_name FROM all_tables ORDER BY table_name ) WHERE ROWNUM <=…

Q: Create a view that lists the ISBN and title for each book in inventory along with the name and phone…

A: creation of a view;   Create and Use a Database View A view is created from a query using the…

Q: based of the image,  write a sql statement that shows the total number of patients handle by each…

A: Given information contains four tables that includes Patient, Quarantine_centre, nurse and…

Q: REQUIREMENTS TABLE: Field Name Data type Field size Constraints Content / Description REQUESTS…

A: The Staff and Admin has many attributes common and hence it seems Admin is sub-type of Staff entity…

Q: Task 4: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is…

A: Here, we are using dateadd function to add 20 days into the invoice date the day today function…

Q: The materials manager at Tricky Pee Furniture Company maintains a list of suppliers for each of the…

A: We need to create table and fill sample data for the given schema.

Q: What are control chart for attributes? Where can you used them?

A: Control chart for attributes: It is a set of control objects defined to track the defects. The…

Q: When an attribute is included in a composite primary key, it automatically becomes a candidate key…

A: Introduction: A single field or a composite expression that satisfies the criteria for a primary key…

Q: Using the Employees table display the department_id and the average salary of all the employees for…

A: A query to calculate average and to retrieve columns from one or more tables is created using the…