Create a database diagram with the entities and attributes

Assignment Help Database Management System
Reference no: EM131144284

Lab 1: Creating a Database Design in Visio

This assignment contains two 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.) Click here to 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. Check with your professor for any additional instructions.

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.Creating a Database Design in Visio.

Reference no: EM131144284

Questions Cloud

Average collection period in days : In 2010, Drew Gooden Company has net credit sales of $1,600,000 for the year. It had a beginning accounts receivable (net) balance of $101,000 and an ending accounts receivable (net) balance of $107,000.
Find the mean and standard deviation for the number : Find the mean and standard deviation for the number of actual voters in groups of 1002. In the survey of 1002 people, 701 said that they voted in the last presidential election (based on data from ICR Research Group). Is this result consistent with t..
Discuss the management of the process : Discuss the management of the process by which policies and strategies relating to technology are formed. - Qualitative Evaluation of the Personal Computer Industry.
What is the maturity date of the note : Galen Wholesalers accepts from Picard Stores a $6,200, 4-month, 12% note dated May 31 in settlement of Picard's overdue account.
Create a database diagram with the entities and attributes : Create a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).
Ronald distributors is a growing company whose ability : Ronald Distributors is a growing company whose ability to raise capital has not been growing as quickly as its expanding assets and sales.
What are the values of the real money supply and the current : Suppose that the nominal money supply is growing at the rate of 10% per year and that this growth rate is expected to persist forever. Currently, the nominal money supply is M=300. What are the values of the real money supply and the current price le..
Develop a plan for system and system testing : Develop a plan for system testing. Include areas that you will test within both the application and a system as a whole and how errors will be tracked and reported.
Etienne company has been in business several years : Bad debts are estimated to be 7% of receivables. Prepare the entry to adjust the Allowance for Doubtful Accounts.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Write sql statements to calculate average salary

Write SQL statements that do the following: Calculate the average salary for all employees. Calculate the maximum salaries for exempt and non-exempt employees.

  Describing the database systems

Summarize your paper by describing the database systems in your workplace, identifying which database systems and architecture they fall under.

  Design work breakdown structure for designing database

Design a work breakdown structure for the task below: Designing the database, Working on the website content

  Is there a polynomial algorithm for testing whether a

Prove that, if R is in 3NF and every key is simple, then R is in BCNF.

  What is the role of the project manager

Discuss why many information technology professionals may overlook project cost managment and how this might affect completing projects within budget.

  Design database for keeping information of actors

Design a database for Ray. For each director, list his or her number and name and the year he or she was born. If the director is deceased, list the year of death.

  Write a create table statement for the department table

Write a CREATE TABLE statement for the EMPLOYEE TABLE.  Email is required and is an alternate key, and the default value of Department is Human Resources.  Cascade updates but not deletions from DEPARTMENT to EMPLOYEE.

  Explain data flow diagram

Which module actually contains the logic to call the Update Credit File Module?

  Explaining uses for views

Views are integral part of virtual private databases, yet views are utilized for many other reasons. Find out many other uses for views.

  Describe a database and its various elements

Describe a database and its various elements. Define Primary Key, foreign key, and metadata.

  Design a case for other student to investigate

You need to design a CASE for other student to investigate. As an example; at the end of this week you should generate the following materials: A case description.

  Product in traditional costing system - bullie manufacturing

Determine the manufacturing overhead cost per unit of each of the company's two products under the traditional costing system.

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