The administrators of Tiny College are so pleased with your design and implementation of their student registration/tracking system that they want you to expand the design to include the database for their motor vehicle pool. A brief description of operations follows: A brief description of operations follows: • Faculty members may use the vehicles owned by Tiny College for officially sanctioned travel. For example, the vehicles may be used by faculty members to travel to off-campus learning centers, to travel to locations at which research papers are presented, to transport students to officially sanctioned locations, and to travel for public service purposes. The vehicles used for such purposes are managed by Tiny College’s TFBS (Travel Far But Slowly) Center. • Using reservation forms, each department can reserve vehicles for its faculty, who are responsible for filling out the appropriate trip completion form at the end of a trip. The reservation form includes the expected departure date, vehicle type required, destination, and name of the authorized faculty member. The faculty member arriving to pick up a vehicle must sign a checkout form to log out the vehicle and pick up a trip completion form. (The TFBS employee who releases the vehicle for use also signs the checkout form.) The faculty member’s trip completion form includes the faculty member’s identification code, the vehicle’s identification, the odometer readings at the start and end of the trip, maintenance complaints (if any), gallons of fuel purchased (if any), and the Tiny College credit card number used to pay for the fuel. If fuel is purchased, the credit card receipt must be stapled to the trip completion form. Upon receipt of the faculty trip completion form, the faculty member’s department is billed at a mileage rate based on the vehicle type (sedan, station wagon, panel truck, minivan, or minibus) used. • All vehicle maintenance is performed by TFBS. Each time a vehicle requires maintenance, a maintenance log entry is completed on a prenumbered maintenance log form. The maintenance log form includes the vehicle identification, a brief description of the type of maintenance required, the initial log entry date, the date on which the maintenance was completed, and the identification of the mechanic who released the vehicle back into service. (Only mechanics who have an inspection authorization may release the vehicle back into service.) • As soon as the log form has been initiated, the log form’s number is transferred to a maintenance detail form; the log form’s number is also forwarded to the parts department manager, who fills out a parts usage form on which the maintenance log number is recorded. The maintenance detail form contains separate lines for each maintenance item performed, for the parts used, and for identification of the mechanic who performed the maintenance item. When all maintenance items have been completed, the maintenance detail form is stapled to the maintenance log form, the maintenance log form’s completion date is filled out, and the mechanic who releases the vehicle back into service signs the form. The stapled forms are then filed, to be used later as the source for various maintenance reports. • TFBS maintains a parts inventory, including oil, oil filters, air filters, and belts of various types. The parts inventory is checked daily to monitor parts usage and to reorder parts that reach the “minimum quantity on hand” level. To track parts usage, the parts manager requires each mechanic to sign out the parts that are used to perform each vehicle’s maintenance; the parts manager records the maintenance log number under which the part is used. • Each month TFBS issues a set of reports. The reports include the mileage driven by vehicle, by department, and by faculty members within a department. In addition, various revenue reports are generated by vehicle and department. A detailed parts usage report is also filed each month. Finally, a vehicle maintenance summary is created each month. Given that brief summary of operations, draw the appropriate (and fully labeled) ERD. Use the Chen methodology to indicate entities, relationships, connectivities, and cardinalities.
> What does e-commerce mean and how did it evolve?
> Define and explain the concepts of method overriding and polymorphism. Use examples in your explanations.
> Define the concepts of class hierarchy, superclasses, and subclasses. Explain the concept of inheritance and the different types of inheritance. Use examples in your explanations.
> What is a class protocol, and how is it related to the concepts of methods and classes? Draw a diagram to show the relationship between these OO concepts: object, class, instance variables, methods, object's state, object ID, behavior, protocol, and mess
> Using an example, illustrate the concepts of class and class instances.
> Why are some table structures considered to be bad and others good and how do you recognize the difference between good and bad structures?
> Explain how encapsulation provides a contrast to traditional programming constructs such as record definition. What benefits are obtained through encapsulation? Give an example.
> Define and contrast the concepts of method and message. What OO concept provides the differentiation between a method and a message? Give examples.
> Discuss the object/relational model's characteristics.
> What are the essential differences between an RDBMS and an OODBMS?
> How would you define object orientation? What are some of its benefits? How are OO programming languages related to object orientation?
> Using a simple invoicing system as your point of departure, explain how its representation in an entity relationship model (ERM) differs from its representation in an object data model (ODM). (Hint: Check Figure G.34.)
> What are the essential differences between the relational database model and the object database model?
> Explain how OO concepts affect database design. How does the OO environment affect the DBA's role?
> What are the advantages and disadvantages of an OODBMS?
> Name and describe the 13 mandatory features of an OODBMS.
> What role does the ER diagram play in the design process?
> Compare and contrast the OODM with the ER and relational models. How is a weak entity represented in the OODM? Give examples.
> What is an object space? Using a graphic representation of objects, depict the relationship(s) that exist between a student taking several classes and a class taken by several students. What type of object is needed to depict that relationship?
> Describe the difference between early and late binding. How does each of those affect the object-oriented data model? Give examples.
> What are the five minimum attributes of an OO data model?
> Explain the concept of abstract data types. How they differ from traditional or base data types? What is the relationship between a type and a class in OO systems?
> Suppose you are currently considering the purchase of a client/server DBMS. What characteristics should you look for? Why?
> Explain what middleware is and what it does. Why would MIS managers be particularly interested in such software?
> What major network communications protocols are currently in use?
> Using the OSI network reference model, explain the communications middleware component's function.
> Describe the client and the server components of the client/server computing model. Give examples of server services.
> Use the following description of the operations of the RC_Charter2 Company to complete this exercise. The RC_Charter2 Company operates a fleet of aircraft under the Federal Air Regulations Part 135 (air taxi or charter) certificate, enforced by the FAA.
> Describe and explain the client/server architectural principles.
> Explain how client/server system components interact.
> What is client/server computing, and what benefits can be expected from client/server systems?
> Discuss and evaluate the following statement: There are no unusual managerial issues related to the introduction of client/server systems.
> Contrast client/server and traditional data processing.
> Describe and contrast the four client/server computing architectural styles that were introduced in this appendix.
> Mainframe computing used to be the only way to manage data. Then personal computers changed the data management scene. How do those two computing styles differ, and how did the shift to PC-based computing evolve?
> You read in this appendix that: An examination of the UCL's Inventory Management module reporting requirements uncovered the following problems: • The Inventory module generates three reports, once of which is an Inventory Movement Report. But the inven
> Modern businesses tend to provide continuous training to keep their employees productive in a fast-changing and competitive world. In addition, government regulations often require certain types of training and periodic retraining. (For example, pilots m
> Describe and discuss the ER model's treatment of the UCL's inventory/order hierarchy: a. Category b. Class c. Type d. Subtype
> During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TEC’s manager gives you the following description of the business: • TEC has a file of candidates who are willing to work. • If the candidate has worked be
> How would you verify the ER diagram shown in Figure QC.4? Make specific recommendations.
> What major factors should be addressed when database system performance is evaluated? Discuss each factor briefly.
> What steps must be completed before the database design is fully implemented? (Make sure that you list the steps in the correct sequence and discuss each step briefly.)
> Why must a conceptual model be verified? What steps are involved in the verification process?
> What is a module interface, and what does it accomplish?
> What is a module, and what role does a module play within the system?
> Write the connectivity and cardinality for each of the entities shown in Question 4. Details from Question 4: PART PART VEND VENDOR PK PART CODE PK,FK1 VEND ID PK,FK2 PART CODE PK VEND ID PART PROD PK,FK1 PART CODE PK,FK2 PROD CODE PROD_CUST PRODUCT
> What is a partial dependency? With what normal form is it associated?
> The dependency diagram in Figure Q6.8 indicates that a patient can receive many prescriptions for one or more medicines over time. Based on the dependency diagram, create a database whose tables are in at least 2NF, showing the dependency diagram for ea
> The dependency diagram in Figure Q6.7 indicates that authors are paid royalties for each book that they write for a publisher. The amount of the royalty can vary by author, by book, and by edition of the book. Figure Q6.7 Book royalty dependency diagr
> Given the dependency diagram shown in Figure Q6.6, answer items 6a-6c: FIGURE Q5.6 Dependency Diagram for Question 6 a. Identify and discuss each of the indicated dependencies. b. Create a database whose tables are at least in 2NF, showing the depen
> When is a table in BCNF?
> When is a table in 3NF?
> When is a table in 2NF?
> When is a table in 1NF?
> Suppose that someone tells you that an attribute that is part of a composite primary key is also a candidate key. How would you respond to that statement?
> How would you describe a condition in which one attribute is dependent on another attribute when neither attribute is part of the primary key?
> Why is a table whose primary key consists of a single attribute automatically in 2NF when it is in 1NF?
> What is a surrogate key, and when should you use one?
> Define and discuss the concept of transitive dependency.
> What are the client/server's infrastructure requirements and how do they function?
> What actions are taken during the database initial study, and why are those actions important to the database designer?
> Set up an integral for the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Then use your calculator to evaluate the integral correct to five decimal places. (a)
> Set up an integral for the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Then use your calculator to evaluate the integral correct to five decimal places. (a)
> Set up an integral for the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Then use your calculator to evaluate the integral correct to five decimal places. (a)
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) Rz about BC
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) Rz about AB
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) Rz about OC
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) R3 about OA
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) R2 about BC
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) R2 about AB
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) R2 about OC
> Sketch the region enclosed by the given curves. Decide whether to integrate with respect to x or y. Draw a typical approximating rectangle and label its height and width. Then find the area of the region. у 3 sin x, у—2х/п, х>0 y
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) R2 about OA
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) R1 about BC
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) R, about AB
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) R1 about OC
> Refer to the figure and find the volume generated by rotating the given region about the specified line. C(0, 1)| R2 B(1, 1) y= Vx A(1, 0) Rj about OA
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. у — х, у — 0, х — 2, х — 4; about x
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. x = y', x = 1 – y²; about x = 3
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. ху— 1, у — 0, х — 1, х— 2;B about x -
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. у —х', у — 0, х — 1; about x
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. y = sin x, y = cos x, 0 < x </4; about y = -1
> Sketch the region enclosed by the given curves. Decide whether to integrate with respect to x or y. Draw a typical approximating rectangle and label its height and width. Then find the area of the region. у — 1/х, у — 1/х, х—2 y
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. y = 1 + sec x, y = 3; about y = 1
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. у — х", у — 1, х — 2;B about y — -3 |3D
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. у —х, х — у?;B аbout y — 1
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. х — 2 — у?, х —у%;B about the y-aхis
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. y² = x, x = 2y; about the y-axis
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. y = 6 – x², y = 2; about the x-axis
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. y = x', y = x, x> 0; about the x-axis
> Find the volume of the solid obtained by rotating the region bounded by the given curves about the specified line. Sketch the region, the solid, and a typical disk or washer. 2х — у?, х — 0, у — 4;B about the y-ахis
> Suppose that a region / has area A and lies above the x-axis. When / is rotated about the x-axis, it sweeps out a solid with volume V1. When / is rotated about the line y = -k (where k is a positive number), it sweeps out a solid with volume V2. Express
> Some of the pioneers of calculus, such as Kepler and Newton, were inspired by the problem of finding the volumes of wine barrels. (In fact Kepler published a book Stereometria doliorum in 1615 devoted to methods for finding the volumes of barrels.) They
> Sketch the region enclosed by the given curves. Decide whether to integrate with respect to x or y. Draw a typical approximating rectangle and label its height and width. Then find the area of the region. у — х3 — 4х, у %3 2х y
> A hole of radius r is bored through the center of a sphere of radius R > r. Find the volume of the remaining portion of the sphere.
> A hole of radius r is bored through the middle of a cylinder of radius R < r at right angles to the axis of the cylinder. Set up, but do not evaluate, an integral for the volume cut out.
> A bowl is shaped like a hemisphere with diameter 30 cm. A heavy ball with diameter 10 cm is placed in the bowl and water is poured into the bowl to a depth of h centimeters. Find the volume of water in the bowl.
> Find the volume common to two spheres, each with radius r, if the center of each sphere lies on the surface of the other sphere.
> Find the volume common to two circular cylinders, each with radius r, if the axes of the cylinders intersect at right angles.
> (a) Cavalieri’s Principle states that if a family of parallel planes gives equal cross-sectional areas for two solidsS1 and S2, then the volumes of S1 and S2 are equal. Prove this principle. (b) Use Cavalieri’s Princip