Creating a database design in visio

Assignment Help Database Management System

Reference no: EM13802990

Lab: Creating a Database Design in Visio

This assignment contains two (2) Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment.

Use "Appendix A: 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.)

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

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.

Reference no: EM13802990

Questions Cloud

How is sodexho using social networking to its advantage : How do the new practices at Sodexho align with the essentials of performance management? How is Sodexho using social networking to its advantage

What is meant by the culture of a society : What is meant by the culture of a society and why is it important for international managers to understand it? Do you notice cultural differences among your classmates?

Juvenile justice and delinquency theory : Juvenile Justice and Delinquency theory

How leaders acquire and lose power within their organization : how can leaders acquire and lose power within their organization? How is position and personal power defined in your current or in a past employment environment?

Creating a database design in visio : Creating a Database Design in Visio- Create a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors)

Four dimensions of culture proposed by hofstede : Describe the four dimensions of culture proposed by Hofstede. What are the managerial implications of these? Compare the findings with those of Trompenaars and the GLOBE project team.

Calculate the scalar potential at the origin : Calculate the electric flux through the cube - calculate the scalar potential at the origin.

Discuss the types of operational conflicts : Discuss the types of operational conflicts that could occur in an international context because of differences in attitudes towards time, change, material factors, and individualism. Give examples relative to specific countries

How does attendance hurt students academically : What are the main causes of poor attendance in college students? How does attendance hurt students academically? What are some solutions to poor attendance?

User Account

All Pages