Describe important application from a management perspective

Assignment Help Management Information Sys

Reference no: EM133957125

Assignment:

The purpose of this assignment is to provide an opportunity to design, implement, and use a database management system.

1. Select an application for which a database management system is needed. Describe the application and state why it is an important application from a management perspective.

2. Create a conceptual model for this application. Be sure to include proper names for entities, attributes, and relationships. Identify min/max cardinalities. You may use either the Chen or Crow's Feet representation. Use a drawing tool to create the conceptual model. There should be 5-8 entities in the conceptual model.

3. Transform the conceptual model into a relational model and show: 1) the transformation rules applied; and 2) the final relational model.

4. Implement the database using your Oracle account provided for this course and populate it with data. Note that you will need to create the data for your relations. Show the populated relations. You can do this by using the "select command.

There should be at least 5-10 entries for each relation. Make sure that the data in the relations are consistent with each other.

5. Identify and run 7 representative, and non-trivial, queries. Show the results. Queries of the form "select *" are considered trivial queries and should not be included. Queries of the form "select name from customer;" are also considered to be trivial queries. At least 4 of the queries must involve two or more relations, so you will need to use join commands. Write the queries in English. Then, use screen shots to show the SQL form of the queries and the results obtained from running the queries on the data you created.

6. Describe any changes to the design that you would make if this database were designed for a real-world implementation.

Reference no: EM133957125

Questions Cloud

What is the mechanism of action of this class of drugs : Corticosteroids are the cornerstone of maintenance immunosuppressive therapy in solid organ transplantation. What is mechanism of action of this class of drugs?

Evaluate intervention and program processes and outcomes : Critically analyze, monitor, and evaluate intervention and program processes and outcomes. Apply evaluation findings to improve practice effectiveness

How do you get certified and licensed in your state : How do you get certified and licensed in your state? What is the primary nurse licensure office resource website in your state?

Why you think this intervention may work or feasible : Why you think this intervention may work or feasible? Any literature may be relevant to select this intervention? What have you tried before, successful or not?

Describe important application from a management perspective : Describe the application and state why it is an important application from a management perspective.

Demonstrate the use of appropriate clinical techniques : Demonstrate the use of appropriate clinical techniques for a range of presenting concerns identified in the assessment including crisis intervention

Urinary tract infection cause : Why would a urinary tract infection cause Jessica to develop nocturnal enuresis? Why does vesicoureteral reflux predispose to urinary tract infection?

Discuss hemoglobin : Discuss hemoglobin. What is it? How does it work? What treatment is indicated for iron deficiency anemia? Both medication and non-medication.

What proportion of the food that older adult consumes daily : According to MyPlate for Older Adults, approximately what proportion of the food that an older adult consumes daily should consist of fruits and vegetables?

User Account

All Pages