1. checkout_date and dvd_ID coulmns should be combined together as a composite primary key of the rental table, and rest columns are NOT NULL constraints except the checkin_date column (it might hold NULL values). 2. Rental table is a child table, and the member_id column is a foreign key column which references member table’s member_id primary key column. 3. Rental table is a child table, and the dvd_id column is a foreign key column which references dvd table’s dvd_id primary key column.

1. checkout_date and dvd_ID coulmns should be combined together as a composite primary key of the rental table, and rest columns are NOT NULL constraints except the checkin_date column (it might hold NULL values). 2. Rental table is a child table, and the member_id column is a foreign key column which references member table’s member_id primary key column. 3. Rental table is a child table, and the dvd_id column is a foreign key column which references dvd table’s dvd_id primary key column.

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter8: Advanced Data Handling Concepts

Section: Chapter Questions

Problem 17RQ

See similar textbooks

Similar questions

State health services follow-upUser loginno new member registrationthe user will be able to follow the results of the assay, the prescribed drugs,You can also make appointments and follow up appointments You write code Java.
school has 100 lockers and 100 students. All lockers areclosed on the first day of school. As the students enter, the first student, denotedas S1, opens every locker. Then the second student, S2, begins with the secondlocker, denoted as L2, and closes every other locker. Student S3 begins with thethird locker and changes every third locker (closes it if it was open and opens it ifit was closed). Student S4 begins with locker L4 and changes every fourth locker.Student S5 starts with L5 and changes every fifth locker, and so on, until studentS100 changes L100.After all the students have passed through the building and changed the lockers,which lockers are open? Write a program to find your answer and display all openlocker numbers separated by exactly one space.
Customer ={idC(PK), surname} Contract ={idC(PK), customer, consultant, insurance_type, date} Consultant means: id of some Staff member Staff={idPerson(PK), surname,dob, boss, email} Dob means: date of birth, boss: is id of another Staff member supervisor Insurance_Type={idT(pk) , Tname , price , length } Length = number of months it is valid (from the date when it was bought ) Find consultants born after some contract was already signed?
1. Display the name (first name and last name) for those employees who gets more salary than the employee whose ID is 163. 2. Display all the information of those employees who did not have any job in the past. 3. Display the details of departments managed by Susan. 4. Display the details of those departments which max salary is 7000 or above for those employees who already done one or more jobs. 5. Display the detail information of those departments which starting salary is at least 8000.
Granite Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mailbox number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This is kept along with the employee’s name and address. For hourly employees, hourly wage and target weekly work hours are stored (e.g. the company may target 40 hours/week for some, 32 hours/week for others, and 20 hours/week for others). Some salaried employees are salespeople that can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their commission percentage on sales and commission percentage on profit are stored in the system. For example, John is a…
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…
*SI schema contains customers that have bought one or more vehicles.They can be classified using the following criteria:Customers that have bought only one car (one-time buyer)Customer that have bought two cars (two-time buyer)Customers that have bought more than two cars (frequent buyer)Using a SINGLE SELECT statement, display a list of customers withtheir names and what type of buyer they are for all those customersthat have bought Mercedes car makes.
ABC is a pharmaceutical company that recruits volunteers for clinical trials on drugscurrently under development at the company. The company conducts multipleclinical trials concurrently. Each clinical trial is assigned a trial code together with description of theclinical trial, start date, end date, and the lead scientist. Each clinical trialinvolves at least one treatment, and each treatment belongs to only one trial.Treatment has its conduct date. When volunteers sign up for a treatment of a clinical trial, their contact detailsincluding full name, address, contact number, email address, as well as theirunique volunteer number are recorded. Each volunteer is involved in at leastone treatment, while each treatment is tested on at least 30 volunteers. In addition, medical details for each volunteer including weight, height, bloodtype, race, gender, and medical condition are also recorded separately. At each treatment each volunteer involves a specific drug of certain type,…
ABC is a pharmaceutical company that recruits volunteers for clinical trials on drugscurrently under development at the company. The company conducts multipleclinical trials concurrently. Each clinical trial is assigned a trial code together with description of theclinical trial, start date, end date, and the lead scientist. Each clinical trialinvolves at least one treatment, and each treatment belongs to only one trial.Treatment has its conduct date. When volunteers sign up for a treatment of a clinical trial, their contact detailsincluding full name, address, contact number, email address, as well as theirunique volunteer number are recorded. Each volunteer is involved in at leastone treatment, while each treatment is tested on at least 30 volunteers. In addition, medical details for each volunteer including weight, height, bloodtype, race, gender, and medical condition are also recorded separately. At each treatment each volunteer involves a specific drug of certain type,…
A restaurant chain has several locations in a city (with a name and zip code stored for each), and each is managed by one manager. Each manager manages multiple restaurants. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, items can appear on multiple menus, and each menu has a price on it. A customer can visit multiple restaurants and a restaurant can have multiple customers. Represent this situation of restaurants with an E-R diagram
"the secretary at the cycling club enrolls applicants as members as soon as he receives their signed application form. He updates the members file with form then issues a membership card. This completes the membership process" - draw the physical DFD and convert it to logical DFD
FOOTBALL-PLAYER(CodFP, Name,Surname, Address, CityOfBirth) TEAM(CodT, Name, Category,ConstitutionDate) AWARD(CodA, CodFP, DeliveryDate, DeliveryPlace, Type) PLAYER-TEAM(CodFP, CodT, StartingDate,EndingDate, NumPlayedMatches, NumGoals) Find name, category and constitution date of the teams in which have played (in any time) the players who received, in their career as a whole, the highest number of awards of type “Best goalkeeper”. SELECT distinct T.Name, T.Category, T.CostituitionDate FROM TEAM T, PLAYER-TEAM PT WHERE T.CodFP= PT.CodFP and PT.CodFP IN (SELECT CodFP FROM AWARD D WHERE A.Type = ‘Best goalkeeper’ GROUP BY CodFP HAVING COUNT(*) = SELECT MAX(AwardTot) FROM (SELECT count(*)as AwardTot AWARD A WHERE A.Type = ‘Best goalkeeper’ GROUP BY CodFP) AS TOTAWARDFP i have this solution but im struggling a lot to be…