Reference no: EM132928765
Scenario
Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.
Instructions for the Database Design Diagram
Use any drawing package or any other application you know such as Visio, Word, PowerPoint, or another tool to create the Database Design Diagram. Otherwise, you may draw the diagram by hand with a pen and paper. If you draw the diagram by hand, then take one or more pictures of the diagram with your cell phone or laptop camera, place the images into a Word document, and submit the document. Otherwise, if you use software to create the Database Design Diagram, then take one or more screen captures of the diagram, place the screen captures into a Word document, and submit the document. Submissions that are not in .doc or .docx format will not be graded.
Include the following in the document:
Draw the entities of the database and the attributes of each entity, based on your research and/or common knowledge of a college and the information tracked by a college.
Create the appropriate relationships between each entity within the diagram.
Describe any assumptions that you had to make about the business rules in order to create the diagram and the associated relationships.
The specific course learning outcome associated with this assignment is:
Draw a database design diagram that depicts the attributes and relationships of the entities.
|
Apply analytical methods to summarize some of target models
: Discussion about findings including any models and Visualizations to support the findings and Data Analysis Findings
|
|
Prepare journal entries to record transactions of honda comp
: Prepare the journal entries to record the above transactions. Honda Company has two classes of share capital outstanding: 7%, Tk 200 par preference.
|
|
Define the characteristics of persona
: Define the characteristics of persona, features, scenarios, and user stories. ALSO, identify the transition sequence between persona and features.
|
|
Prepare schedule showing intangible assets section of smc
: Prepare schedule showing the intangible assets section of SMC's statement of financial position at December 31, 2018 according to IAS-38.
|
|
Database Design Diagram
: Use any drawing package or any other application you know such as Visio, Word, PowerPoint, or another tool to create the Database Design Diagram.
|
|
What is the value of the loom
: What is the value of the loom? A loom is expected to produce regular annual cash flows of $15,000 with the first regular cash flow
|
|
What is the payment expected to be in three months
: The interest rate on the loan is 2.92 percent per quarter. What is the payment expected to be in 3 months? Round your answer to the nearest cent
|
|
Security disadvantages of cloud-based solutions
: List the security advantages of cloud-based solutions. List the security disadvantages of cloud-based solutions.
|
|
What is the present value of the cash flows associated
: Kuley bought a new loom today, If the discount rate is 7.12 percent, then what is the present value of the cash flows associated with this transaction?
|