Creating a database design in visio

Assignment Help Basic Computer Science
Reference no: EM13766927

Creating a Database Design in Visio

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:

Section 2: Design Summary

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 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: EM13766927

Questions Cloud

Compute the squares of the numbers in the array : Write a java program to find the number in the given list. Write a java program to find the location of an element in the list.
Did your life become just a bit easier : Naturally, left-handed people have adapted to the right-handed world to the extent that most are ambidextrous.Lefties, what did you get from this? Did your life become just a bit easier?
The correlation between chronic conditions and optimum healt : Can a person with a chronic condition also experience optimum health? Why or why not - provide rationale.
A columnist for a metropolitan newspaper : Research Problem 2. Stuart is a columnist for a metropolitan newspaper. He holds a degree in journalism from a major midwestern university. For the past 10 years, Stuart has prepared his own income tax returns. He finds doing so to be challenging and..
Creating a database design in visio : 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 te..
Write a paper about novel island of dr moreau by h g wells : Write a literary analysis paper about the novel of "Island of Dr. Moreau" written by H. G. Wells. This essay requires university level of writing, supported by academic sources.
Calculate difference between daily and annual compounding : Calculate the difference between daily and annual compounding, given the following information: (a) PV: $23,000, (b) NPER: 30, and (c) RATE: 5%.
Accounting for a specific circumstance : From the e-Activity research you gathered, analyze how you, as the Chief Financial Officer (CFO) of a "big box store" that has potential pollution, environmental-disposal, or demolition problems, would handle these costs in your financial statemen..
How does the concept of limited liability impact business : 1. According to the concept of limited liability, the liability of shareholders of a company is restricted to the face value of shares. They have no personal obligation for the liabilities of the company.Consider the concept of limited liability and ..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Give a cfg for the set of all well formed strings

Give a CFG for the set of all well formed strings over {a,b,+,.,*, ?,?,(,) } that are well formed regular expressions over {a,b}

  Write general set of instructions will allow us to change

Write a general set of instructions that will allow us to change any displayed value (from 0 to 9) to any desired value (from 0 to 9) in the least number of steps. For example, if the displayed value is 1 and the desired value is 0,

  Explain legal reasons for not performing examination

Legal reasons for not performing examination on suspect's computer, but sometimes you have to compromise. If we make compromise, is it acceptable by court?

  Discuss the role of cognitive psychology

Explain and justify the need for good HCR practice and discuss the role of cognitive psychology in the design of user interfaces and select appropriate communication styles for interactive systems.

  What is a hash value

What is a hash value, and why do you think it is important?

  Indicate a need for modification in a cloud computing

What method would you use to monitor success and indicate a need for modification in a cloud computing environment? Needs to be 250 words and APA format and at least one reference with in-text citations.

  Write a program that prompts the user to input a string

Write a program that prompts the user to input a string and then outputs the string in the pig Latin form. The rules for converting a string into pig latin form are described in Programming example : Your program must store the characters of a str..

  Determine the number of distinct labelling of knn do the

1. determine the number of distinct labelling of knn. do the same for kmm and kmnl2. give an example of a graph g with

  Introduction to programming

Many financial experts advise that property owners should insure their homes or buildings for at least 80 percent of the amount it would cost to replace the structure.  Design a modular program that asks the user to enter the replacement cost ..

  Determine the equivalent units of production for the month

Micro Labs uses a processing costing system. The following data are available for the mixing department for October. The department started 175,000 gallons into production during the month.

  Compute the total asset value

For this project assume that an organization has five total servers. One server has a TCO of $25,000, two servers have a TCO of $37,000 and the remaining two servers have a TCO of $42,000. The servers are not used by internal employees but are ..

  Create an array of five shippedorder objects

Create 4 Order class fields: order number, customer name, quantity ordered, and total price. Create public accessors for each field except total price.

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!

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