Create a data dictionary showing the column names

Assignment Help Database Management System

Reference no: EM131850356

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 specificcompany, 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, identifytwoentity typesthey 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. See page 15 in your book for an example.

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: EM131850356

Questions Cloud

Type of food and later intelligence : Why can't the researchers draw a causal connection between type of food and later intelligence?

Determine which entails which by giving a valid proof : One of these two statements entails the other, but not the other way round. Determine which entails which by giving a valid proof of one from the other.

What political interest does the agency serve : Using urban's website, write a two-page paper to answer the questions below. Use headings to indicate sections of your paper.

Cogency of inductive arguments : 1. If know just the true values of a deductive argument's premises, then you will know whether the argument is sound T or F?

Create a data dictionary showing the column names : Create a data dictionary showing the column names, table names, data type, and length for the entities in #2. See page 15 in your book for an example.

Michael assets that are covered by deposit insurance : What is the total balance of Michael's assets that are covered by deposit insurance?

Sources of inaccuracy in performance measurement : Our textbook discusses a topic called Sources of Inaccuracy in Performance Measurement. Read the topic thoroughly to understand the sources of inaccuracy.

What effect does entrepreneurship have on economies : What effect does entrepreneurship have on economies and societies throughout the world? Required Text: Entrepreneurship 5th Edition

Discuss why is some degree of monopoly power permitted : Discuss why is some degree of monopoly power permitted? In this Apply the Principle, you will have to decide if Google has too much monopoly power.

User Account

All Pages