Question 54 Delivery trucks enter and leave a depot through a controlled gate. At the depot, each truck is loaded with packages, which will then be delivered to one or more customers. As each truck enters and leaves thedepot, the following information is recorded and uploaded to a database.• The truck's identification numberThe truck's weight• The date and time the truck passes through the gate• Whether the truck is entering or leaving the depotUsing only the information in the database, which of the following questions CANNOT be answered?AOn which day in a particular range of dates did the greatest number of trucks enter and leave the depot?BWhat is the average number of customer deliveries made by each truck on a particular day?What is the change in weight of a particular truck between when it entered and left the depot?DWhich truck has the shortest average time spent at the depot on a particular day?

Answered: Question 54

Engineering

Computer Science

Question 54

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

A trucking company has trucks and drivers and wants to build a database to track truck activity. Each truck is identified by a VIN (Vehicle ID Number) which is 10 characters long. The database also stores the make, model and year of the truck. Drivers are identified by SSN (Social Security Number) which is 9 characters long. The database also stores first name, last name and address of each driver. Trips are also stored in the database. Each trip has one truck making the trip, one driver, date of trip, and total miles covered. Any driver can be assigned to any truck. Write the tables and attributes you would need to have in your database to track this information. Draw the tables and attributes using the format, underlining the primary key (or otherwise showing what the primary key is): TABLENAME1(FIELD1, FIELD2, .. ,FIELDN) TABLENAME2(FIELD1, FIELD2, .. ,FIELDN)
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…
A pharmacy database tracks prescriptions written by doctors and purchased by patients at pharmacy locations. A prescription is written by a doctor for one or more drugs for exactly one patient. The prescription also specifies the pharmacy where the prescription is to be filled. The doctors identifier is called the National Provider Identifier (NPI). Every drug is identified by a National Drug Code (NDC). A prescription contains the following information. The NPI, NDC, date the prescription was written, and the patients identifier. Write a qeury that shows the prescription number, patient's name, the brand name for the drug, dosage, doctor's city for all prescriptions filled by a doctor whose NPI IS AT20030040 and written on or after January 1, 2022. The database tables are designed as shown below. You do not need to create the database to answer this question but you might if you want to visualize the connections. CREATE TABLE DRUG (NDC VARCHAR(20) NOT NULL,DRUG_BRAND_NAME VARCHAR(25)…
Database Systems Each branch of the Jaja restaurant has a mainstay menu that is very popular with customers, so information on the availability of the number of servings is needed to be able to serve orders. Here are two transactions that are ordering a food menu at the same time. T1: Start the transaction at time t1, read 10 servings of food stock at t2. Because ordering one portion, the stock is reduced by 1 at t3. On t6, update the stock count, and commit to t7. T2: Transaction T2 starts a transaction on t2, reads the number of stocks in t3 as many as 10. At t4 orders 3 portions. On t5 it updates the stock to 7 and then on t6 commits it. As a result of the T1 and T2 transactions above, there was an error in the amount of food stocks. Make a solution with 2PL. What kinds of problems happened? Give a reason why choosing this type of problem! How much food is still available?
The Ch07_LargeCo database stores data for a company that sells paint products . The company tracks the sale of products to customers . The database keeps data on customers (LGCUSTOMER), sales (LGINVOICE), products (LGPRODUCT), which products are on which invoices (LGLINE), employees (LGEMPLOYEE), the salary history of each employee (LGSALARY_HISTORY), departments (LGDEPARTMENT), product brands (LGBRAND), vendors (LGVENDOR), and which vendors supply each product (LGSUPPLIES). Some of the tables contain only a few rows of data , while other tables are quite large : for example , there are only eight departments , but more than 3300 invoices containing over 11000 invoice lines . For Problems 28-55 , a figure of the correct output for each problem is provided . If the output of the query is very large , only the first several rows of the output are shown .
Computer Science Doctor Patient Portal We here propose a doctor patient handling, managing system that helps doctors in their work and also patients to book doctor appointments and view medical progress. The system allows doctors to manage their booking slots online. Patients are allowed to book empty slots online and those slots are reserved in their name. The system manages the appointment data for multiple doctors for various date and times. Each time a user visits a doctor his/her medical entry is stored in the database by doctor. Next time a user logs in he may view his/her entire medical history as and when needed. At the same time a doctor may view patients medical history even bore the patient visits him. This allows for an automated patient doctor handling system through an online interface. Our system also consists of organ donor module. This module allows for organ donation registration as well as organ search. The module is designed to help urgent organ requirements…
Assume a university database's student table has indexes on StudentID (the main key) and Major, Age, MaritalStatus, and HomeZipCode (all secondary keys) (all secondary keys). Imagine the university requested a list of students majoring in MIS or computer science who were over the age of 25, married, and from the 45462 zip code OR students majoring in computer engineering who were single and from the 45462 zip code. How can indexes be used to restrict results to to those records that fulfill this condition?
in mysql Take a picture of the inputs and outputs Create a user with the name IS Sead and password a789 and give him permission to connect to the databaseCreate a role function that includes allowing to create a table and create a view and then granting that function to the Sead . user Make the sead user give permission to query and enter on the student table for all users in the databaseHave the user sead withdraw the entry on the student table from user saa
Create a Database with at least 4 tables, 3 queries, 2 forms, and 1 report. Topic: can be based on Restaurant management. It can be used to record the database like restaurant name and location, employee names and IDs, the capacity of the restaurant (smoking and non-smoking), hours of operation (assume same hours every day), employee salaries, and titles.
This organization provides following functionalitiesEmergency Care 24x7Support GroupsSupport and Help Through callsAny new Patient is first registered in their database before meeting the doctor. TheDoctor can update the data related to the patient upon diagnosis (Including thedisease diagnosed and prescription). This organization also provides rooms facility foradmitting the patient who is critical. Apart from doctors, this organization has nursesand ward boy. Each nurse and ward boy is assigned to a doctor. Also, they can beassigned to patients (to take care of them). The bill is paid by the patient with cashand E-banking. Record of each payment made is also maintained by the organization.The record of each call received to provide help and support to its existing person isalso maintained.Check clinic management system project in PHP
In MS Access, a calculated field such as Total Price: [price] * [quantity] differs from a table field in what way? Question 18 options: 1) There is no difference. They are just synonyms for the same concept. 2) A sum cannot be computed for a calculated field. 3) A calculated field should be saved in the table after its value has been computed. 4) A calculated field's value appears in the output of a query datasheet, but it is not physically stored as a field in the table.
After you have secured a position working on a database, you will need to decide whether you will employ a trigger or a process. When is the appropriate time to pull a trigger, and what exactly are those triggers?