Define the relationships between entities

Assignment Help Database Management System
Reference no: EM131429757

You have learned some database components such as entities (tables) with attributes (columns/fields) and keys in previous lessons such as Relational Databases, Database Fields and Field Specifications, and Establishing Keys.

Now based on the examples in those lessons, you will design a database for CTU, which includes three entities (tables): Students, Faculty, and Classes. Note a class refers to a particular class section. For example, the current CS251 you are taking is one class instance (i.e. CS251-01), and another CS251 section is another class instance (i.e. CS251-02). And it should also have session information (i.e. 1604A).

In summary, create a Word document for your design which includes:

Three entities and each entity should have at least three attributes.

Properly Identify all Primary (Use Solid Underlines) and Foreign Keys (Use Dotted Underlines)

Define the relationships between entities (See examples in Data Model and Database Entities and Relationship Modeling lessons)

Create an entity-relationship diagram (ERD) from the entities. You may use SmartDraw, Visio, Erwin, or even PowerPoint or Word to draw the diagram. Take a screenshot (no need if you use Word) and insert it into the Word document.

Reference no: EM131429757

Questions Cloud

Report on network management tools : In this paper, you will research and report on network management tools associated with (1) policy compliance, (2) bandwidth management, and (3) asset management
Distribution of drivers : Does the data indicate that the distribution of accidents for the three age groups is significantly different from the distribution of drivers? Test with ox=.05.
Provide an instance of a security breach for each year : For this assignment, you will review the Communication and Collaboration Timeline media that presents past information technology advances, along with specific information security breaches. You are to review the timeline, which ends at the year 2..
Four outcomes of a random experiment : A decision maker subjectively assigned the following probabilities to the four outcomes of a random experiment P(E1)=.10 P(E2)=.15 P(E3)=.40 P(E4)=.20, Are these probability assignment valid? Explain.
Define the relationships between entities : You will design a database for CTU, which includes three entities (tables): Students, Faculty, and Classes. Note a class refers to a particular class section. For example, the current CS251 you are taking is one class instance (i.e. CS251-01), an..
Probability of selecting a value at random : a. What is the area between 415 pounds and the mean? b. What is the area between the mean and 395 pounds? c. What is the probability of selecting a value at random and discovering that it has a value of less than 395 pounds?
How do all levels of management demonstrate leadership : You have been hired as a consultant to design BCP for SanGrafix, a video and PC game design company. SanGrafix's newest game has become a hot seller, and the company anticipates rapid growth. It's moving into a new facility and will be installing..
Average annual income of a sample : What is the probability that the average annual income of a sample of 100 defense attorneys is more than $120,000?
What is crime mapping and how can it solve cases : Go to the Get a Real Degree website, located at http://getarealdegree.com/what-is-crime-mapping-and-how-can-it-solve-cases/, and read the article titled "What is Crime Mapping and how can it Solve Cases"

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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