Define basic entity relationship diagram colleges

Assignment Help Database Management System
Reference no: EM13304211

Basic Entity Relationship Diagram

Colleges and universities must draw a clear connection between the requirements of the field for which the student is being prepared and the things required of the student as part of that preparation process. That connection must be tracked through four steps:

1. The knowledge base of the field;
2. The program goals for the degree or certificate being sought;
3. The learning outcomes for each course offered in that degree or certificate program; and
4. The assignments included in each course.

It would be very beneficial to have a database to support the required tracking. For this assignment you need to:

1. List the entities that would be necessary to model such a database.
2. Identify for each entity the necessary attributes.
3. Develop an Entity-Relationship Diagram that models the database.
4. You may hand-draw and scan your ERD, create the ERD in Word, PowerPoint, or Access, or use a dedicated ERD creation program such as E/R Assistant, available for download at:

https://highered.mcgraw-hill.com/sites/0072942207/student_view0/e_r_assistant.html

Reference no: EM13304211

Questions Cloud

What is the cost of equity based on the dcf approach : Assume that you are a consultant to Morton Inc., and you have been provided with the following data: D1 = $1.00; P0 = $25.00; and g = 6% (constant). What is the cost of equity based on the DCF approach?
Major ecological imbalance on earth : Major ecological imbalance on Earth is between the human species and the rest of Earth''s biota - What are two specific actions we could do to achieve a balance (for example, recycling)? Here is the critical part:
What might be reasonable costs of capital for average-risk : Suppose a firm estimates its cost of capital for the coming year to be 10 percent. What might be reasonable costs of capital for average-risk, high-risk, and low-risk projects?
Immediate customer and supplier : In an independent supply chain, the participants collaborate solely on the interactions between the immediate customer and supplier. On the other hand, in a vertical marketing system:
Define basic entity relationship diagram colleges : E-R diagram - Basic Entity Relationship Diagram Colleges and universities must draw a clear connection between the requirements of the field for which the student is being prepared and the things required of the student as part of that preparation pr..
Would you expect the distribution between dividend yield : Would you expect the distribution between dividend yield and capital gains to be influenced by the firm's decision to pay more dividends rather than to retain and reinvest more of its earnings?
Is this statement true or false : However, the second series contains an annuity. Is this statement true or false?
Do you think the internet has made the students less ethical : Do you think the Internet has made the students less ethical and should there be a code of Ethics for Internet authors and what can colleges do today to help encourage academic integrity and deter unethical behavior?
Evaluate the wavelength of the laser : A diffraction grating has a spacing of 350 lines per mm and sits L = 47.7 cm from a screen. what is the wavelength of the laser

Reviews

Write a Review

Database Management System Questions & Answers

  Interface with some other dbms

Develop a RDBMS (Relational Database Management System) in Python. The RDBMS should actually be written in Python, not just interface with some other DBMS. This system should track students: Personal Data, Schedules and Grades. The system should cont..

  Your task is to develop a database to support this activity

Your task is to develop a database to support this activity.Here is what you need to be able to provide Custom Auto Body in order to land your first consulting contract:

  Create database of measured meteorological data

You are creating a database of measured meteorological data for use in weather and climate research. Explain a structure type measured_data_t with components site_id_num.

  Find the names of employees with the highest salary

Find all department(s) with at least two employees of different names and find the department(s) with the most people and find the names of employee(s) with the highest salary.

  Query using a literal character string

query specifying specific columns query using a column alias query using the concatenation operator query using a literal character string

  Construct a data warehouse bus matrix

First construct a Data Warehouse Bus Matrix to identify the company's business processes and any likely Data Marts and design the star schema for any Data Marts you have identified.

  Find name and membership number of members

Find the name and membership number of members who have borrowed more than five different books of that publisher.

  Explain database models-hierarchical and relational

Explain each of three database models, hierarchical, relational, and object-oriented, and provide specific referenced example of each of these model types implemented in a functioning database

  Key functions of organization-map to strategic information

From information system point of view, we should take the key functions of organization and map them to strategic information. Do your companies follow this process or are steps skipped?

  Relational algebra expressions for names of salespeople

Illustrate relational algebra expressions for names of all salespeople, names of all salespeople having ORDER row and names of salespeople not having ORDER row.

  Potential sales and department store transactions

Identify the potential sales and department store transactions that can be stored within the database and design a database solution and the potential business rules that could be used to house the sales transactions of the department store.

  Create mock-up report to make the monthly claim

He wishes you to group data by insurance company number, with subtotals by company and grand totals for each numeric field.

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