Categories: Homework on time

You have learned some database components such as entities (tables) with attributes (columns/fields)

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.

Don't use plagiarized sources. Get Your Custom Essay on
You have learned some database components such as entities (tables) with attributes (columns/fields)
Just from $13/Page
Order Essay
superadmin

Share
Published by
superadmin

Recent Posts

Consider the following information, and answer the question below. China and England are internation

Consider the following information, and answer the question below. China and England are international trade…

4 years ago

The CPA is involved in many aspects of accounting and business. Let’s discuss some other tasks, othe

The CPA is involved in many aspects of accounting and business. Let's discuss some other…

4 years ago

For your initial post, share your earliest memory of a laser. Compare and contrast your first percep

For your initial post, share your earliest memory of a laser. Compare and contrast your…

4 years ago

2. The Ajax Co. just decided to save $1,500 a month for the next five years as a safety net for rece

2. The Ajax Co. just decided to save $1,500 a month for the next five…

4 years ago

How to make an insertion sort to sort an array of c strings using the following algorithm: * beg, *

How to make an insertion sort to sort an array of c strings using the…

4 years ago

Assume the following Keynesian income-expenditure two-sector model:

Assume the following Keynesian income-expenditure two-sector model:                                                AD = Cp + Ip                                                Cp = Co…

4 years ago