Reference no: EM131441975
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.
|
Locate a company involved in international logistics
: Locate a company involved in International Logistics and discuss how it addresses its Global involvement.
|
|
Describe at least two common security threats against wired
: Management is pleased with the progress that has been made and likes the steps you have taken to set up a secured network environment. During the last status meeting, it was asked, has everything been done that is possible to ensure the security o..
|
|
How you plan to pitch the release
: Please submit your finalized media release. Remember, the release should fit on a single page, including headings and contact detail. Include a cover message on to whom and how you plan to pitch the release. Free to brainstorm about news angles, w..
|
|
Identifying and establishing priorities
: Explain the concept of needs assessment as properly identifying and establishing priorities regarding human resource development activities at three levels: organization, task and person (CO B).
|
|
Create an entity-relationship diagram from the entities
: 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 examp..
|
|
Compute internal rate of return
: Issues with Internal Rate of Return: Investing or Borrowing: watch the direction of cash flows 1 2 3 C0 C1 C2 C3 IRR NPV @ 10% 1,200.00 (3,500.00) 4,450.00 (2,000.00) Restate Cash Flows from Above C0 C1 C2
|
|
Provide a brief historical view of the organization
: Review of the literature: Students must provide a brief historical view of the organization and assess the company's current challenges. This review will include an examination of other organizations with similar situations.
|
|
Discuss about the behavioral and attitudinal vulnerabilities
: The probability of a risk is not the only metric in determining what risks to mitigate. The cost and time associated with the risk, and the overall impact to the organization are some of the factors that must be considered as well.Think about the ..
|
|
Reasons that corporations invest in securities
: Discuss the reasons that corporations invest in securities. Distinguish between the cost and equity methods of accounting for investments in stocks.
|