Creating a database design in visio

Assignment Help Data Structure & Algorithms

Reference no: EM13764812

Creating a Database Design in Visio

Designing Databases with Visio Professional: A Tutorial," to help you complete Section 1: Visio Database Design. (Note: This tutorial focuses on the use of Microsoft Visio. Open source applications are not covered in Appendix A; however, the use of open source applications within labs is permitted.) Click hereto download Appendix A.

Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab:

Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.

Section 1: Visio Diagram

(Microsoft Visio or equivalent)

1. Use Microsoft Visio (or open source equivalent) in which you:

a. Create a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).

Section 1 of your assignment must follow these formatting requirements:

Submit the Visio diagram as a Visio file.
Section 2: Design Summary

(Microsoft Word or equivalent)

2. Write a one (1) page paper in which you:

a. Discuss the degree to which you believe the Visio diagram reflects the database design.

Section 2 of your assignment must follow these formatting requirements:

Submit the design summary as a Microsoft Word file.

Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format.
Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page is not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

Describe the role of databases and database management systems in managing organizational data and information.
Compose conceptual data modeling techniques to capture the information requirements.
Use technology and information resources to research issues in database systems.
Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

Reference no: EM13764812

Questions Cloud

Main points of the us supreme courts opinion in both case : What specific language in the U.S. Supreme Court decision may have contributed to the ongoing debate to overrule Roe v. Wade? Main points of the U.S. Supreme Court's opinion in both cases

Identify significant ideas about government : Identify the most significant ideas about government that are represented in the readings from this lesson. Discuss how the different ideas that you present impacted the development of the American nation.

Pretrial detention and the concept of bail : Create a 6 to 9 slide presentation in which you explain the pretrial process, along with the following associated activities: Pretrial detention and the concept of bail

Review the courts decision in marburyand : Review the Court's decision in Marburyand determine whether the Court acted in any fashion in order to improve the system of checks and balances that exits among the branches of government

Creating a database design in visio : Designing Databases with Visio Professional: A Tutorial," to help you complete Section 1: Visio Database Design. (Note: This tutorial focuses on the use of Microsoft Visio.

Objectives for complex financial instruments and transaction : Provide examples of important audit objectives for complex financial instruments and transactions For each audit objective that you identify, list one or more audit procedures that could be used to accomplish that objective.

Challennges of imposing australian taxes off-shore : Read the materials and develop the key arguments for an against imposing GST on off-shore on-line purchasers under $1000 :giving consideration to the interests of Australian retailers, consumers and the economy and any practical challennges of imp..

Describe religious undercurrent that led to to enlightenment : Describe the social and religious undercurrent that led to the Enlightenment in America.

Problem related to assessing a research study : Identify an article that directly references your chosen study and compare it to your findings. Does this article refute or confirm the study's findings?

User Account

All Pages