User Account

All Pages

Present a detailed data model for your project scenario

Assignment Help Database Management System
Reference no: EM131519800

Assignment

Present a detailed data model for your project scenario. You can create your data model using Microsoft Visio 2010, which you will have access to through iLab and Microsoft Excel, which comes with Microsoft Office. Other tools may be used as long as the output is legible and conforms to standard format. (i.e., I will not be able to grade the data model if I cannot tell what it is supposed to be!). Your data model should include a minimum of an ERD and metadata chart (data dictionary).

Deliverables for This Task

1. Task 0 proposal (with any revisions or updates)
2. A completed Data Model to include the following.

o An ERD, showing all tables, related attributes, and the primary and foreign keys. This diagram must show both the relationship and cardinality of the relationship using accepted notation. The ERD should be formatted to allow printing on a single 8x10 page. It should be submitted as a Word file (copy and paste from Visio).

o A Data Dictionary (or meta data chart) showing a minimum of the table name, columns, data types, length, and constraints. It should be submitted as an Excel file. Follow the format of the Data Dictionary supplied for Lab 3.

Reference no: EM131519800

Questions Cloud

Locate an article on current budgeting issue : Locate an article on the Internet that addresses a current budgeting issue for an area of criminal justice administration in the state of Idaho
Discuss the transactions for hurricane company : On October 1, 2012, Hurricane lends $8,000 to another company. The other company signs a note indicating principal and 8% interest will be paid to Hurricane.
Advertising-public relations-personal selling : Name and briefly describe the nine elements of the communication process. Why do marketers need to understand those elements?
Change in stock price and change in stock percent : The firm has just announced that because of a new joint venture, it will likely grow at a 14.0 percent rate. How much should the stock price change
Present a detailed data model for your project scenario : Present a detailed data model for your project scenario. You can create your data model using Microsoft Visio 2010, which you will have access to through iLab.
Systems in the market for electronic gadgets : In 2006, Dexel Electronics Inc. introduced audio systems in the market for electronic gadgets. Because of an increase in sales volume as well as a growing.
Description of the client and client demographics : A description of the client and client's demographics. A description of relevant history (family, developmental, and social)
Discuss the prospects for success in the selected country : Analyze why the specific actions taken by the leadership of the selected country have failed.
What is its after-tax cost of preferred stock : what is its after-tax cost of preferred stock?

Reviews

Write a Review

Database Management System Questions & Answers

  Write a prolog program that implements a family database

Write a PROLOG program that implements a family database for your family. Save it as an ordinary text file named family.pro. Your program should implement the following facts for your immediate family, grandparents, and great-grandparents.

  Explain how subqueries and joins are interchangeable

Explain how subqueries and JOINs are interchangeable. Provide SQL syntax examples. Upload your scenario, SQL query syntax, and a screenshot of the data results into the discussion board for review.

  Prepare a database tables with appropriate field-naming

Create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved.

  Write methods for outlier detection

Exceptions in credit card transactions can aid us fraudulent use of credit card. Suggest two methods for outlier detection.

  Integration of information from the participating databases

Create an integration/metadata/ontology layer on top of these two inventory databases, local DB1 and local DB2

  Does the relational model as seen by an sql query writer

Does the relational model, as seen by an SQL query writer, provide physical and logical data independence? Explain.

  Address what makes database connectivity so complex

Address what makes database connectivity so complex and what could be done to simplify it.

  Draw the relationships between the tables

Draw the relationships between the tables. Assume that a DEPARTMENT does not need to have an EMPLOYEE, but that every EMPLOYEE is assigned to a DEPARTMENT.

  Describe your experiences related to your setup of mysql

Install EasyPHP and MySQL and take a screen shot that shows the MySQL prompt on your screen. (Note: You must include the screen shot which shows that MySQL is installed on your computer as part of your assignment. An installation guide to aid the ..

  Suppose that you are the database developer for a local

suppose that you are the database developer for a local college. the chief information officer cio has asked you to

  Question 1 consider the relational schemapartpart-id name

question 1. consider the relational schemapartpart-id name costsubpartpart-id subpart-id counta tuple p1 p2 3 in the

  Use the client table as the source for the mailing labels

Use Avery C2163 labels, and use the default font and color settings. (Hint: Make sure the English option button is selected in the Unit of Measure section.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd