A car-rental company maintains a database for all vehicles in its current fleet. For all vehicles, it includes the vehicle identification number, license number, manufacturer, model, date of purchase, and color. Special data are included for certain types of vehicles: Trucks: cargo capacity. Sports cars: horsepower, renter age requirement. Vans: number of passengers. Off-road vehicles: ground clearance, drivetrain (four- or two-wheel drive). Draw E-R diagram and make sure to indicate key attributes, cardinality, and participation constraints.

A car-rental company maintains a database for all vehicles in its current fleet. For all vehicles, it includes the vehicle identification number, license number, manufacturer, model, date of purchase, and color. Special data are included for certain types of vehicles: Trucks: cargo capacity. Sports cars: horsepower, renter age requirement. Vans: number of passengers. Off-road vehicles: ground clearance, drivetrain (four- or two-wheel drive). Draw E-R diagram and make sure to indicate key attributes, cardinality, and participation constraints.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Big Data

Section: Chapter Questions

Problem 4SAT: The ______________ model is a simple but highly useful way to organize data into collections of...

See similar textbooks

Similar questions

Think about a student database with the StudentID as the main key and the Major, Age, MaritalStatus, and HomeZipCode indexes (all secondary keys). If the institution requested a list of MIS or computer science majors who were over 25, married, and from the 45462 zip code OR computer engineering majors who were single and from the 45462 zip code, then let's pretend they were both over 25 and from the 45462 postcode. How can indexes be used to guarantee that only the data that satisfies this criteria is accessible to users?
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows:  Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genres (such as horror, action, drama, and so forth).  Each movie has one or more directors and one or more actors appear in it. Each movie also has a plot outline. Finally, each movie has zero or more quotable quotes, each of which is spoken by a particular actor appearing in the movie.  Actors are identified by name and date of birth and appear in one or more movies. Each actor has a role in the movie.  Directors are also identified by name and date of birth and direct one or more movies. It is possible for a director to act in a movie (including one that he or she may also direct).  Production companies are identified by name and each has an address. A production company produces one or more…
The ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.
Please make the authentic ERD AND RELATIONAL MODEL BY KEEPING ALL RULES OF IT IN MIND A cooking club organizes several dinners for its members. The purpose of the club is to allow several members to get together and prepare a dinner for the other members. The club president maintains a database that plans each meal and tracks which members attends each dinner, and also keeps track of which members creates each dinner. Each dinner serves many members and any member is allowed to attend. Each dinner has an invitation. This invitation is mailed to each member. The invitation includes the date of the dinner and location. Data about members like their name, membership no, contact no and email address are saved.Each dinner is based on a single entrée (starter) and a single dessert. This entrée and dessert can be used again for other dinners.• Consider the above scenario you are required to create ERD for the above scenario first then covert the ERD into Relational Model
Draw the ERD with appropriate mapping cardinalities for mail order database in which employees, each identified by unique employee number, first name last name and ZIP code. Employee are categorized as manager, clerk ad delivery staff. Each customer of the company is identified by a unique employee number, first and last name and ZIP code. Each part sold by the company is identified by unique part number, part name, price and quantity stock. Each order placed by a customer is taken by a clerk and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded. The delivery boy places the order of specified customers. There is a provision of replacing one or many fault parts to the customer but before that it must be verified by the manager.
This question is related to the Database:- Suppose you are creating a database for a library management system. Explain how you would make a table for the "books" entity and insert some sample data, and then alter the table to add a new column for the "authorID" attribute and update "authorID" with some data. Finally, make a SQL query to retrieve all the books that were published after the year 2000. Note that this book schema has several columns, including "book_id" as the primary key, "title", "authorN", "publisher", "publication_year", "isbn", "language", and "num_pages". It also includes "available" column that is set to "true" by default and can be used to track the availability of the book. Please don't use handwriting...
1. A movie may have many actors, and an actor can act in many movies. An actor can play more than one role in the same movie. Suppose we try to represent this in our database using an Actor table, a Movie table, and a Role table. The Role table has a foreign key to reference the Actor table, plus the name of the role and the title of the movie. a) There might be actors who do not have roles in the Role table b) The actor referenced might not exist in the table c) A role might list a movie title that does not exist in the Movie table d) There could be more than one actor with the same name 2. Suppose we have the following relational model: Movie(mov_id(PK), title, yr) Person(pid(PK), fname, lname, gender) Acts_In(actor_id(PFK), movie_id(PFK), role) -- actor_id references Person, movie_id references Movie What would be true of the following query? SELECT fname, lname FROM Movie m, Acts_In a, Person p WHERE mov_id = movie_id AND actor_id = pid AND yr = 2022 a) It…
Consider the unnormalized data presented in the STUDENT table below:a) Identify the data redundancies and give reasons why they create problems in schemas. STUNUM STUNAME TUTNUM TUTNAME COURSENUM COURSEDESC GRADE 00118536 John Brown RC985 Rose Carter CS1001 CS1002 CS1003 Comp Research English Database design B A A 00118537 Marie Smith TB526 Tom Black CS9001 CS9002 CS1002 Calculus Javascript English A B C 00118538 Mary Cole PF587 Peter Finch CS9002 CS1003 CS1001 Javascript Database design Comp Research C A A 00118539 Ian Dunkley SH231 Sarah Hardy CS9005 CS9006 CS1002 Information Systems Web Design English A B B 00118540 Bob Marley JH850 Jacqui Hart CS9002 CS1002 CS1003 JavaScript English Database Deign A B C b) Which dependencies represent 1NF violations? Identify and eliminate 1NF violations. Present your table(s) after transformation into 1NF.c) Identify and remove any 2NF violations. Show the resulting schemas and tablesd) Identify and…
For example, here are some statements that would describe the sample data and show that the database meets the design requirements. 1. There are 10 students in the database. 2. The siblings are: Mary and John Smith; David, Thomas, and Sally Jones etc. 3. Each student has at least one designated adult who can pick up the student from school. Etc.
Air West Airlines is a regional carrier that operates primarily in the southwestern United States. Draw an ER diagram to capture the following information in a database for the airline company. An airport is identified by a unique airport code and has a location which consists of (city, state), an elevation, and one or more phone numbers. An airport may have several flights to arrive at it and depart from it. A flight has a unique flight number, a base fare, and the number of seats. A flight can arrive at one or more airports and depart from one or more airports. For each arrival, the scheduled arrival time should be recorded. For each departure, the scheduled departure time should be recorded. Each flight has one or more staff members in its crew. Each staff member (who may be an attendant or a pilot, but not both) has a unique ID number, a name, and a hire date. A staff member may be assigned to several flights. Each flight attendant has a date for an advanced certification. Each…
PART B Consider the college database you implemented in the image provided and answer the following questions. i. Write SQL statements to populate the relevant tables with the following data Studno givenName familyName faculty hons year courseno equipmentused subjectsubject 220123 Angel Matheaus FCI Computer Science 2 CSC101 laptop java 227456 Michael Jackson ACC Accounting 3 ACC510 calculator Statistics 223546 Joy Willian MGT Management 1 MGT305 project leadership Name roomno course Andrea Kulima 709 ACC510 Princess Bukohwo FCI 6 CSI101 Peter Jones 201 MGT305 Thandeka Pheto OB 12 CSI101 All staff (appraisees) are appraised by Thandeka Pheto. ii. Write an SQL statement to change Thandeka Pheto’s room number to “PH506”iii. Joy Willian decided to transfer to another college, write SQL statement to remove her details from the college’s database. iv. Write an SQL query to show all students in year 2 of their studies v. Write an SQL query to list all…
IN a staywell Database Model, Task 1: For every property, list the management office number, address, monthly rent, owner number, owner’s first name, and owner’s last name. table should have this headings ; OFFICE_NUM ADDRESS MONTHLY_RENT OWNER_NUM FIRST_NAME LAST_NAME