(Answered) The data dictionary is a database management system dbms

Others

The data dictionary is a database management system (DBMS) component that stores the definition of data characteristics and relationships. This "data about data" is called metadata. This week, you will utilize a relational database development environment to manipulate data in the AdventureWorks database. It will be helpful to first understand something about the physical structure of this database.

Analyze the AdventureWorks 2008 database metadata to address the following in your post:

· How many tables are in the AdventureWorks 2008 database?

· Based on the AdventureWorks 2008 data dictionary, how many entities would be included in the logical data model of this database? Defend your answer.

· Identify five tables in the AdventureWorks database. Provide the description of each table and discuss how each table is used.

· View the CustomerAddress Table, Customer Table, Address Table, and AddressType Table.

· Identify the primary key of each table.

· Discuss which tables have a foreign key relationship with another table.

· Discuss some of the different data types you viewed in the database tables.

Your initial post should be a minimum of three hundred words.

View complete question

Homework Help/Study Tips, Others

Category:- Homework Help/Study Tips
Reference No.:- M92410653
Price:- $25

Verified Expert

Priced at $50 Now at $25, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Homework Help/Study Tips

What are the recommendations to avoid health risks in

What are the recommendations to avoid health risks in school-aged children

Discussion 2 pagesbased on the research that you have so

Discussion ( 2 pages) Based on the research that you have so far conducted, consider the makeup and the history of the community affected by your chosen public health issue. Take into account social determinants, epidemi ...

Question before beginning work on this assignment please

Question: Before beginning work on this assignment, please review the expanded grading rubric for specific instructions relating to content and formatting. For your project, using the South University Online Library or t ...

Describe the economic and industry dynamics of the cityin

Describe the Economic and Industry Dynamics of the City In the class we discussed several articles and watched many videos on the economic and industrial dynamics of our cities on such topics as how the manufacturing ind ...

-how do your own morality and self-control influence your

-How do your own morality and self-control influence your behavior? How do they influence your choice of peers? Situations you find yourself in? -In your opinion, should integrated theories seek to be parsimonious such a ...

Question option 1 assignment 11 depends upon the article

Question: Option 1: Assignment 1.1 depends upon the article called "The Believing Game" by Peter Elbow. Please read it (attached here for convenience) and respond. What do you think about the idea of using an imaginative ...

Sdvmonica has a biology mid-term exam on thursday on the

SDV Monica has a Biology mid-term exam on Thursday. On the night before the exam, Monica has a hard time falling asleep and when she does, she has various nightmares about taking tests. The day of the exam, Monica decide ...

1 assemble a set of guidelines on conducting preliminary

1. Assemble a set of guidelines on conducting preliminary investigation for a criminal case. 2. Propose one (1) strategy that criminal investigators should take in order to conduct an efficient follow-up investigation. P ...

Identifying political issuesthis activity will have you

Identifying Political Issues This activity will have you identify political issues facing healthcare administrations and discuss how you would handle the situations presented. Unit Outcomes addressed in this Assignment: ...

Qstion read case study sleeping on the job of your

Question: Read Case Study "Sleeping on the Job," of your textbook. Then, answer the following questions: 1. Should the company's treatment of the grievant for the first two "sleeping on the job" incidents influence the o ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Homework Help/Study Tips Expert