Q&A Hero

Question

Plymouth Car Rental (PCR) started in with two compact cars and has expanded its fleet of vehicles with several sedans and trucks. When a customer books a rental, his/her age has to be at least 18 for compact cars and sedans, which are rented by the day and must be returned the following morning by 11 AM. Trucks are rented for a maximum of six hours. The owner requires a deposit on the reservation to be paid within seven days of booking. Vehicle records consist of the makes and types (Honda sedan), color, seating capacity, required deposit, rental rate and rental limit (in hours). Customer data consists of customer's names, addresses, phone numbers, and birth dates. Bookings identify the customer, vehicle, as well as the time rented and returned. There can be several payments up until the reservation date. Payments must reflect the payment status for each booking, including deposit, when the deposit was made, then each of the payments made, and when the entire payment was completed.
In addition, PCR decided to reward their customers who refer other customers with gas coupons on their future rentals (which also servers the purpose of retaining those customers). Because the business is booming, PCR added several other vehicles, both trucks and sedans and wants to expand information gathered on these. In particular, PCR wants to track several truck-related attributes such as towing capacity and whether it has a snow plow or not. For the sedans, geared towards nature explorers, it wants to track the type and capacity of bike racks, and whether it has a canoe rack.
For questions 82 - 86, please refer to the preceding paragraph.
Describe the nature of recursive relationship in this case (if any) and discuss how it would be modeled in the ER diagram for this database.

Answer

This answer is hidden. It contains 389 characters.

Related questions

Q: Draw the appropriate server control that will allow you to display the customer data and describe the steps needed for proper configuration.
Q: The most appropriate server control that will allow the user to indicate the presence (yes) or absence (no) of a certain property is called a(n) __.
Q: The first step in configuring the GridView control is to __.
Q: The details of the data connection can be saved in a file called __.
Q: The server control used to access a Microsoft SQL Server database qtax is _.
Q: Which of the following steps in the configuration process of a SqlDataSource server control designates a particular SQL Server database to connect to? a) Connecting to a database b) Saving the connection to a file c) Creating a new data connection d) Choosing the data provider
Q: In an ASP page, the view used to directly enter HTML statements is which of the following? a) Datasheet view b) Design view c) Source view d) Code view
Q: Major components of Web Developer is(are) which of the following? a) An ASP page b) Solution Explorer c) Properties window d) All of the above
Q: Which one of the following is a typical Web Form control and an associated event? a) Button, Update b) Drop-down list, Delete c) Text box, Change d) Label, Click
Q: When the Web Form is sent back to the Web server, which of the following occurs? a) User and event-related information is returned. b) All the returned information is analyzed. c) Database is updated if necessary with new information. d) All of the above
Q: The fourth step in the basic ASP model is which of the following? a) Server sends Web Form from the Web server. b) User requests Web Form from the user's browser. c) Web server processes data and returns form to the user's browser. d) User enters data and returns form to the Web server.
Q: The third step in the basic ASP model is which of the following? a) Server sends Web Form from the Web server. b) User requests Web Form from the user's browser. c) Web server processes data and returns form to the user's browser. d) User enters data and returns form to the Web server.
Q: Jerry, the owner of Exotic Flower's Inc., built a small greenhouse to store several types of exotic flowers that he purchases from wholesale suppliers around the world. Each exotic flower Jerry buys and resells falls into one of several flower groups that differ with respect to their storage needs, duration, time in bloom, price, etc. Each of the orders placed by customers specifies the type of exotic flower, the supplier it came from, the date of order, expected delivery date, flower condition on delivery, as well as the quantity ordered. Customer's data contain all the standard information needed to collect payment and deliver the flowers.For questions 86-89, please refer to the preceding paragraph.Draw the appropriate server control and describe the steps of creating the new connection and selecting the appropriate server provider, assuming flower database is available on SQL Server.
Q: ASP Web page is constructed using which of the following? a) Text and graphics b) User input and events c) Data from a database d) All of the above
Q: GridView server control requires the number of columns and rows to be specified in advance in order to provide the appropriate space.
Q: GridView server control is used to display data in the form of a table.
Q: The advantages of saving connection to Web.config file include easier deployment and portability.
Q: Storing connection strings simplifies database maintenance.
Q: All types of data sources require some form of user authentication.
Q: An ASP.NET Web Form is divided into the user interface and programming logic components.
Q: When a button is clicked or list selection made, an event is raised and the information is just displayed in the user's browser.
Q: Web Form sent back to the Web server contains both user supplied and other relevant information associated with the ASP Web page.
Q: ASP.NET server controls include dynamic versions of typical HTML tags.
Q: In SQL Query Analyzer, the statement used to retrieve all of the client's contacts and emails would be __.
Q: In SQL Query Analyzer, the statement used to display employee names together with job dates and times, for all jobs starting on either 3/12/06 or at 8 A.M., would be which of the following? a) Select employee. name, job.jobdate, job.timestart, job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.jobdate = #3/12/06# And job.timestart = #8:00 AM# b) Select employee. name, job.jobdate, job.timestart , job.timeend From employee Inner Join job On employee.ssn = job.jobid Where job.jobdate = #3/12/06# Or job.timeend = #8:00 AM# c) Select employee. name, job.jobdate, job.timestart , job.timeend From employee Inner Join job On employee.ssn = job.ssn Where job.jobdate = #3/12/06# Or job.timestart = #8:00 AM# d) Select employee. name, job.jobdate, job.timestart , job.timeend From employee , job On employee.ssn = job.ssn Where job.jobdate = #3/12/06# Or job.timestart = #8:00 AM#
Q: In SQL Query Analyzer, which of the following statements would result in contacts, emails, and zip codes for the clients whose emails end in "net", and who live in 03264 zip code? a) Select contact, email, zipcode From client Where email Not Like "net" And zipcode!= "03264" b) Select contact, email, zipcode From client Where email Like "*net" Or zipcode = "03264" c) Select contact, email, zipcode From client Where email Like "net" Or zipcode = "03264" d) Select contact, email, zipcode From client Where email Like "*net" And zipcode = "03264"
Q: In SQL Query Analyzer, which of the following statements would result in contacts and emails only for the clients in 603 area code? a) Select contact, email From client Where phone Not Like "603*" b) Select contact, email From client Where phone Like "603" c) Select contact, email From client Where phone Like "603*" d) Select contact, email From client Where phone Like "*603*"
Q: In SQL Query Analyzer, the bottom pane shows the query results.
Q: Design the query that calculates the order totals for each of the customers, sorted descending by the totals. Include the customer names, order dates, as well any other information you deem necessary.
Q: Create the query that calculates the "Average Time to Delivery" from lowest to highest, grouped by supplier, and only for the flowers delivered in good condition.

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts