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.
|
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"
|