The problems below use the Customer, OrderTbl, and Employee tables of a simplified Order Entry database. The Customer table records clients who have placed orders. The OrderTbl contains the basic facts about customer orders. The Employee table contains facts about employees who take orders. The primary keys of the tables are Cu
Write the proper sequence of activities in the design of a rental video database. (The initial ERD was shown in the figure). The design must support all rental activities, customer payment tracking, and employee work schedules, as well as track which employees checked out the video to the customers. After you finish writing the
The questions are also in the pdf file. Question 3. Following a new rule of the company, some customers' insurance rates need to be adjusted. The following query counts the number of such customers. Select count(*) From customer Where (age > 20 and ticketNumber >= 5) or age < 18 Assume that the date distribution of th
This question deals with the significance of null values and how they are different from blank or zero value. It also probes whether null values are requires or not
What is the main argument for and against NULL? Do you think NULL values should be allowed? Why or why not?
A tiny college wants to keep track of the history of all administrative appointments (date of appointment and date of termination) (hint: time variant data are at work) The tiny college chancellor may want to know how many deans worked in the college of business between january 1, 1960 and january 1 2008 or who the dean of the c
Describe the relationships related to databases for Huffman Trucking Driver's Log : 1. One to one 2. One to many 3. Many to many
Please explain how a databses management system (DBMS) and data mining can help a motor vehicle maintenance center improve its services, and what tables would be needed in such a database. Also what additional way can the DBMS and data mining be used to imporve customer service.
In a report that less than half of all organizations validate the in thier databases and test the database management system's functionality. Why is this? do you think a cetain type or size of organization is more likely to skip these tests than another? Please explain your reasoning. Please help need right away Thanks
What are triggers used for, and why are they important in database systems? Provide an example of a situation where a trigger would be appropriate. What would the implementation of this trigger look like?
Database Management - A college course may have one or more scheduled sections, or may not have a scheduled section.
A college course may have one or more scheduled sections, or may not have a scheduled section. Attributes of COURSE include Course_ID, Course_Name, and Units. Attributes of SECTION include Section_Number and Semester_ID. Semester_ID is composed of two parts: Semester and Year. Section Number is an integer (such as "1" or "2"
See attached file for diagram. b. Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table. c. Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table.
Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD?
1) For each table, identify a super key and a secondary key. TABLE SUPERKEY SECONDARY KEY TRUCK BASE TYPE Reference Figures: TABLE PRIMARY KEY FOREIGN KEY(S) TRUCK BASE TYPE See attached
1) Do the tables exhibit entity integrity? Answer Yes or No, and then explain your answer. TABLE ENTITY INTEGRITY EXPLANATION TRUCK BASE TYPE TABLE PRIMARY KEY FOREIGN KEY(S) TRUCK BASE TYPE
1. Suppose that you are using the database composed of the two tables shown in Figure Q3.12. a. Identify the primary keys. b. Identify the foreign keys. c. Draw the entity relationship model. FIGURE Q3.12 The Ch03_Theater Database Tables
List the rows in each of the joined tables. Use the small database shown in Figure Q3.5 to illustrate the difference between a natural JOIN, an equiJOlN, and an outer JOIN. (See attached file for data)
Describe how you would design a database to keep track of all the students at a university. describe tables, relationships, attributes, Primary Keys, Foreign Keys, Candidate Keys. Describe minimum and maximum cardinalities for each relationship. Make sure the database is normalized. Items to keep track of in database: fi
This solution provides an overview of a Disaster Recovery Plan
Browse the Web and find Web sites that fit the following content types. Write a summary of how the content is presented at each Web site and describe how each Web site focuses on its users' needs. Linear Hierarchical
What types of tasks would benefit from databases utilizing workflow technology? Describe briefly any workflow database that you know of.
A small airport: We require a data base for a small airport. The data base should track airplanes, pilots, hangars, airplane types, mechanics and airplane owners. The airport maintains the usual data, on airplanes: registration number, on airplane types: model, capacity and weight , on hangars: hanger number, location
Analyze the use of databases in your organization. Include what database applications are used (Microsoft Access, DB2, Oracle, etc.). Conclude by proposing improvements. For large organizations, restrict the scope to the department in which you work. If you are not employed, consider the use of databases and the benefits the
Develop an entity relationship diagram (ERD) for your project database based on the initial data requirements. The company that we are working on distributes many products, like secure bolts and screws, to many different construction companies. In order for the company to be successful it is important for them to keep a rel
I am having a problem with criteria range. I do not know how to set two different criterias in one column. I need to ADVANCE FILTER all of the Clerks (1 and 2) and the Sect. 1 workers who make more than $5.50/hr. I do not understand how to set the title criteria for more than one title. It HAS to be advanced filtered, not auto-f
Prepare a systems analysis report detailing Ace's problem and a systems solution that can be implemented using PC database management software.
Ace Auto Dealers specializes in selling new vehicles from Subaru. The company advertises in local newspapers and is also listed as an authorized dealer on the Subaru Web site and the major Web sites for auto buyers. The company benefits from good local word-of-mouth reputation and name recognition and is a leading source for Sub
1. Ray wants to start a DVD rental program at his stores that he plans to call Henry's DVD Club. He refers to each of his customers as "members." Each member in the club is assigned a number. He also stores the members' names and addresses. In addition, he stores the number of rentals the member has made and the date the member
Describe the different ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, buildings, and phone numbers) and faculty (numbers and names). No office house more than one faculty member; no faculty member is assigned more than one office. Illustrate the ways of implement
1. When a database approach is used, a failure on the part of one user that damages the database can affect other users. What are some specific examples of database failures? 2. If you were one of the users of a damaged database, how would you be affected by such a failure and what measures could you take to prevent it?
Please answer the attached questions. Referential Integrity Check Question 1 - Given the following data types of some table fields and the simple schema of the relational database they are a part of, inspect its relationships for any referential integrity violations. If any exist, list what they are: Note: You can assum
In a clerical office/job placement (staffing agency) setting, what are the typical uses of Microsoft Access as a database? What are the typical improvements that can be suggested for Microsoft Access in a clerical setting? What other databases (Oracle, DB2, etc) would be known to benefit a clerical/job placement (staffing