Create the data dictionary for your complete data model

Assignment Help Computer Engineering

Reference no: EM13462249

1. Indentify all entities that you would need to track data about for the business case (people, places, things, or events) and list them.

2. Could you use a spreadsheet to keep track of this data? What would be the advantages and disadvantages of doing so?

3. Using Visio or any other drawing software, draw the ERD (attributes, entities, , relationships and cardinalities (e.g. one-to-one, one-to-many) of the database used to support the operations of the business described in the case. The ERD should identify primary keys and foreign keys.

4. Create the data dictionary for your complete data model (Please see attached template datadictionaryTemplate.xls so you can see an example on how to create a data dictionary).

5. Write 2 queries (in SQL or plain English) that a manager could answer using this database. Your queries must each imply the use of at least three tables.

6. Please identify the DMBS technology that you would use to implement the database. Please justify your selection.

7. Your work will be graded based on the rubrics attached (assignment2Rubric.xls). Please check the rubric so you can see how this work will be assessed.

Reference no: EM13462249

Questions Cloud

Prepare an 8-10-page report in word this report should : prepare an 8-10-page report in word. this report should include a project history of your recent trillo apparel

Analyzed and described whether the organization should : information technology evolves rapidly and businesses must stay abreast of that evolution in order to remain

The document must be complete and demonstrate that you can : this is an individual project. using the case study below develop a 3 - 5 page paper that is well organized and

Prepare a written review of an article from a recent : prepare a written review of an article from a recent business magazine. also prepare a powerpoint presentation as

Create the data dictionary for your complete data model : 1. indentify all entities that you would need to track data about for the business case people places things or events

Conduct research and provide a two page apa response : 1.conduct research and provide a two page apa response. describe and discuss the following topics regarding nonlinear

Choose an organization from the choices provided and : choose an organization from the choices provided and prepare an organization security plan that provides security

How the national security telecommunications and : how the national security telecommunications and information systems security policy nstissp national policies

Assume that past data indicates that one fp translates into : 1. a function based analysis for a software system for managing security at home safehome system v5.4 is given below

User Account

All Pages