Describe assumption that you had to make about business rule

Assignment Help Computer Engineering

Reference no: EM133508390

Homework: Drawing an Entity Relationship Database

Preparation

In this homework, you will be drawing an Entity Relationship Diagram (ERD) or Database Design Diagram.

Scenario

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.

Instructions for the Database Design Diagram

Use any drawing package or any other application you know such as Visio, Word, PowerPoint, or another tool to create the Database Design Diagram. Otherwise, you may draw the diagram by hand with a pen and paper. If you draw the diagram by hand, then take one or more pictures of the diagram with your cell phone or laptop camera, place the images into a Word document, and submit the document. Otherwise, if you use software to create the Database Design Diagram, then take one or more screen captures of the diagram, place the screen captures into a Word document, and submit the document. Submissions that are not in .doc or .docx format will not be graded. Include the following in the document:

Question 1. Draw the entities of the database and the attributes of each entity, based on your research and/or common knowledge of a college and the information tracked by a college.

Question 2. Create the appropriate relationships between each entity within the diagram.

Question 3. Describe any assumptions that you had to make about the business rules in order to create the diagram and the associated relationships.

Reference no: EM133508390

Questions Cloud

Describe steps involved in business process re-engineering : Describe the steps involved in business process re-engineering and how they are closely linked to ERP implementation.

Understanding and skills in social media analytics : BUS5CA Customer Analytics and Social Media, La Trobe University - Social Media Analysis for Understanding Customer Preferences and Sentiments

Describe instrumentation you can procure or prepare now : Describe instrumentation you can procure or prepare now or in an early sprint to ensure timely measurement and performance evaluation of the features that are d

Explain the company net profit margin : Please plot on graph the Strategic Group Map for Netflix. On the X axis plot the Asset Turnover, and on the Y axis plot the ROS and represent the Equity

Describe assumption that you had to make about business rule : Describe any assumptions that you had to make about the business rules in order to create the diagram and the associated relationships.

What loyalty should a multi-national firm feel towards : What loyalty should a Multi-national firm feel towards the country in which it was incorporated? -Are international trade agreements good or bad?

Can canada be considered a culturally-linguistic market : Can Canada be considered a "culturally-linguistic" market? Why or why not?? Mexico for Latin America and much of the Hispanic United States.

Explain the network topology that best fits the scenario : Explain the network topology that best fits the scenario. You will create a high level network diagram to show the layout of the specified requirements.

What was the original sales revenue : What was the original sales revenue? $0.00 Round to the nearest cent What were the original variable costs? $0.00 Round to the nearest cent

User Account

All Pages