A database is to be designed for a Universal Vehicle Rental Co. (UVRC). The information required includes a description of vehicles in their fleet, customers and company revenues from renting the vehicles.Each vehicle  has a unique VIN number, make, model,  year of production, as well as the standard daily rental price. The data about customers UVRC does business with includes unique customer ID, customer name , customer address, customer type (regular or preferred) and at least one phone number. Each  rental event UVRC keeps track of has a unique invoice ID,  vehicle check out date, the vehicle check in date as well as the total revenue generated from the eventA vehicle can have up to 300 rental events in one fiscal year. Some vehicles may not be rented out at all during one fiscal year for various reasons.  Each rental event involves one and only one vehicle.Each customer UVRC keeps track of is involved in at least one rental event in a fiscal year. Each rental event involves one and only one customer.There are no multi-day discounts, but preferred customers get 20% off the standard daily price for every day they rent a vehicle.

A car insurance company has a large database that stores customer details, including the vehicles they own and past claims. The structure of the database means that information is stored in tables, rows, and columns. What type of database is this?An XML databaseAn object databaseA relational databaseA non-relational database

CD Motors is a second-hand car dealership. They keep records of all the cars on their forecourt including those that have been bought and sold in a relational database.A sample of a table called 'Cars' from the database is shown.The cars table includes Car Reg, Make, Model, Engine, Type, Year, Doors and Miles. Three cars are shown with the data: VN67 VWS, Volkswagen, Up!, 1.0, Petrol, 2017, 5, 29000 FH15 HVM, Vauxhall, Corsa, 1.3, Petrol, 2015, 5, 15600 VK13 DMX, Kia, Sportage, 1.7, Petrol, 2013, 5, 19200Write a SQL statement that will return the registration for all cars manufactured after the year 2016.[3]

There 3 car rental agencies. Each agency requires the data in XML, but in a different format, what are the right set of design patterns to be used?Pick ONE optionStrategy & FactoryFilter & FactoryObserver & BuilderDecorator & Builder

Patricia, a database system manager for a large hotel chain, is setting up a relational database to track customer hotel registrations for each hotel. The table in the database currently includes fields (columns) for First Name, Last Name, Phone, Email, License Plate #, and Check-in Date.What can Patricia do to make sure that each record (row) in the database is unique?answerDesignate the Phone field as the primary key.Combine the Email field and the Phone field to use as the primary key.Designate the License Plate # field as the primary key.Create an additional Check-in ID field.

Question 10You are a database administrator for a car dealership. The company is growing, and the number of cars the company needs to keep track of has increased. The limitations of the current database design have become more noticeable. There is a lot more repeated data, such as car makes, models, and VIN numbers. This redundancy is causing issues with data integrity and making queries slow. In the tables below what are the primary and foreign keys?