Identify the types of data a company might be interested

Assignment Help Management Information Sys

Reference no: EM131844288

Assignment : Who uses databases?

In this assignment, you will identify three companies and think critically about how they use databases to enable their business.

After completing this assignment, you should be able to identify the types of data a company might be interested in storing, and how it is related to other data. You should also begin to see complexities in identifying how data is stored.

1. Choose three of the categories below and identify one specific company, organization, or service from each.

	Banking/Finance	Retail	Education	Entertainment
Examples	Banks Investment firms Insurance	Physical stores Online stores Convenience stores	Grade schools Colleges Training seminars Online learning	TV, music, and movies Streaming services Television networks Gaming
	Food Services	Healthcare	Service	Transportation
Examples	Restaurants Groceries Farming Food production	Doctors, dentists, etc. Hospitals/urgent care Pharmacies	Government svcs. Postal service Construction Lawn care	Auto manufacturing Taxi services Airlines Shipping

2. For each company, identify two entity types they need to keep track of.

3. For each type of data, identify five attributes for each entity type you identified in #2

4. Create a data dictionary showing the column names, table names, data type, and length for the entities in #2.

5. Draw an ERD showing the relationship between the two entities. Include the cardinality and participation constraints. You do not need to show the attributes in the ERD. It is easiest to make these drawings in software such as PowerPoint or Visio.

6. For each entity, provide 3-7 instances using fictional data. Createand populate a table for each entity that includes sample valuesthat demonstrate the participation and cardinality.

7.Write out the business rules that are presented in your ERD. The business rules should describe the entities, their attributes, domain constraints (optional, but should be included if needed), cardinality, and participation constraints. You may either write this in long form or use bullet points.

Reference no: EM131844288

Questions Cloud

Describe project integration management : Describe project integration management. How does it relate to the project life cycle, stake-holders, and the other project management knowledge areas?

Product and its branding and packaging strategies : Choose a brand that you feel loyal to and describe the product and its branding and packaging strategies.

Introducing a new product to the market : Put yourself in the position of an entrepreneur who is developing a new product or service to introduce into the market. Briefly describe the product.

Most communication in our day to day lives : It's been generally noted that most communication in our day to day lives is actually nonverbal. Since this is the case, which forms of nonverbal communication

Identify the types of data a company might be interested : Identify three companies and think critically about how they use databases to enable their business.

Prepare a selling expense budget : Preparing a budget and analyzing the results of operations in relation to the budget will help you understand how to use financial information.

False with regards to audit responsibility : Which of the following is false with regards to audit responsibility? What would be Fern's component cost of preferred stock?

Regulations limiting cross-ownership : In the following question which one is correct answer? 1. Regulations limiting cross-ownership are primarily designed to

What is the operating cash flow for the project in year two : The tax rate is 34 percent and the required return on the project is 11 percent. What is the operating cash flow for the project in year 2?

User Account

All Pages