Explore BrainMass


I have 1 question below ..

I need answers of below questions: #1. Design a relational database containing information about music composers, their lives, and their compositions. (Avoid redundancies similar to those in Figure 9.4) Sorry for disturbing you, the problem is that I don't listen to any type of music hence I don't know the names. Than

Systems Analyst's Decision Process

From the System Analyst's perspective, below are several situations calling for decisions about output, content, output methodology, distribution and son on. For each situation, note the appropriate output decision. Be brief. a. A large, well-regarded supplier of key raw materials to your company's production process requires

MS Access and ERD Normalization

MUST USE Microsoft Access, create the keys and relationships between tables for the Huffman Trucking Driver Log for the original tables. Please make sure you include the primary and foreign keys for all 3 tables. Part 2.B-Normalize the ERD and explain the level of normalization. The explanation can be done in a word document w

Federated database

What is a federated database and why are federated databases becoming increasingly common? What are examples of databases in your current or previous work environment that could be federated?(I don't have any experience with this) how could the metadata be managed for a federated database?

Entities and Relationship Diagrams: Example Problem

For each following statement, please give the corresponding E-R diagram (entities and relationship), and the structural constraints (Cardinality and Participation). a) A supplier supplies certain number parts for a project, a project uses the parts from the different suppliers, and the same kind parts from different suppliers

Database Analysis: Data Modeling and E-R Diagrams

After completing a course in database management, you have been asked to develop a preliminary ERD for a symphony orchestra. You discover the following entity types that should be included: - CONCERT SEASON The season during which a series of concerts will be performed. Identifier is Opening_Date, which includes Month, Day, a

Database Concepts for EER Models

Develop an EER model for the following situation using the traditional EER notation, the Visio notation or the supertypes notation. An international school of technology has hired you to create a database management system to assist in scheduling classes. After several interviews with the president, you have come up with the f

Simple Relationship Diagrams: ER diagrams

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

Database Proper Sequences

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

Customers' Insurance Rates

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

Administrative Appointments ERD

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

Service Mining

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.

Ensuring Data base Quality

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

Use of Triggers in Databse Systems

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 problem and dependency diagram

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.

Databases-ERD diagram requirement

Problem: Draw the entity relationship diagram for this database. Reference Figures: TABLE PRIMARY KEY FOREIGN KEY(S) TRUCK BASE TYPE

Databases - Identification of candidate key

Do the tables exhibit referential integrity? Answer Yes or No, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key. TABLE REFERENTIAL INTEGRITY EXPLANATION TRUCK BASE TYPE Reference Figures: TABLE PRIMARY KEY FOREIGN KEY(S) TRUCK BASE TYPE

Databases referential integrity

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

Identification of keys and entity relationship model

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

Database of Tracking Students

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