Reference no: EM13785727
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.) Click here to download Appendix A.
After reviewing your database design from Lab 1: Creating a Database Design in Visio, the college has provided more information for the database that they want developed:
For each student, the college needs to track the student ID, student names, addresses, start date, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender, and birth date.
For each course, the college needs to track the course ID, course name, department, quarters offered, sections, and instructor teaching each course.
For each instructor, the college needs to track the instructor ID, name, address, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender, birth date, and the courses that each instructor is qualified to teach.
Additionally, the college needs to track the final grades for each student after each course has completed.
Section 1: Modified Visio Diagram
(Microsoft Visio or equivalent)
1. Use Microsoft Visio (or open source equivalent) in which you:
a. Modify the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).
b. Create the appropriate relationships between each entity within the diagram.
Prepare the amortization schedule
: Using Excel, prepare the amortization schedule and then record all required journal entries that would be made by Barker on the following dates (a) December 31, 2012; (b) December 31, 2013; (c) December 31, 2014; (d) December 31, 2015; and (e) Dec..
|
Major concerns-issues or questions regarding sexuality
: Write and post a deep, critical-thinking response to this poem. What is Olds trying to say? Let's link it to healthy and unhealthy love and relationships as well as the friends with benefits saying.
|
Cultural demographics of your community
: Cultural demographics of your community - Age breakdown of your community and how the demographics and age affect your local health care market
|
Write paper on drug control in central asia
: Write paper on given topics: "Drug Control in Central Asia" and "Crackdown on Corruption"
|
Create the appropriate relationships between each entity
: Modify the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors). Create the appropriate relationships between each entity within the diagram.
|
Importance of ethics in the accounting profession
: Ethics requirements of the Board of Accountancy for the State in which you intent to pursue CPA licensure. Current trends and events illustrating the importance of ethics in the accounting profession.
|
An assignment on career development plan
: Career Development Plan
|
Most important areas of economics
: What do we mean when we talk about "leading indicators"? Just what is a leading indicator anyway - Discuss one of the most important areas of economics, namely the use of leading economic indicators to forecast the future direction of the macroecon..
|
The biblical mandate for resolving conflict
: Specify a method for how you will accomplish your purpose and answer your question. This step is a preview of your research, and you will briefly indicate the tools you used to conduct your study. You may use any number of methods: surveying litera..
|