IM 305 ENTIRE COURSE


Ask a Question

IM 305 ENTIRE COURSE

Sale price $50.00 Regular price $100.00

IM 305 ENTIRE COURSE
 
 
 
IM 305 Week 1 Individual Assignment Service Request SR-bi-000 – Hotel Reservations, Part 1
 
Resources: Service Request SR-bi-004 – Hotel Reservations and BRD Template on your student website
Select and complete one of the following assignments:
Option 1: Business Requirements Document
Create a business requirements document using the BRD Template for a new database taken from the set of business rules provided in the service request.
Option 2: UML Use Cases
Create a set of use cases that describe the requirements for the new database based on the business rules provided service request.
 
 
 
 
IM 305 Week 1 DQS
 
DQ 1
 
Write a 200- to 300-word short-answer response explaining the steps you would take to develop a logical design from a set of business rules. Include the possible pitfalls that may be encountered during the process.
 
 
DQ 2
 
Write a 200- to 300-word short-answer response explaining how the use of ERDs compares to using UML as a method of documenting the logical design of a database?
 
 
 
 
 
 
IM 305 Week 2 Individual Assignment Service Request SR-bi-000 – Hotel Reservations and a Microsoft® Visio® diagram
 
Resources: Service Request SR-bi-000 – Hotel Reservations and a Microsoft® Visio® diagram
Create a full logical design using the requirements you gathered and the instructor feedback you received during Week One. Your design must be normalized to at least the third normal form.
Demonstrate this logical design using an enhanced ERD built with Microsoft® Visio® Database Model Design Template.
 
 
 
 
IM 305 Week 2 DQS
 
DQ 1
 
Write a 200- to 300-word short-answer response to answer the following questions:
 
What is added to the ERD to make it meet the enhanced ERD standard?
 
DQ 2
 
Write a 200- to 300-word short-answer response to answer the following questions:
 
What are the advantages and disadvantages of using a case tool in the database design process?
 
IM 305 Week 3 Individual Assignment  Service Request SR-bi-000 – Hotel Reservations, Part 3
 
Resources: Service Request SR-bi-000 – Hotel Reservations and the Oracle® Database Express® Virtual Desktop
Complete your logical design and create an Oracle® database that meets your logical design specifications.
Create a DDL script by going to Utilities->Generate DDL and creating a script file with all tables, indices, sequences, and triggers in your database. Submit this file as a part of your assignment.
 
 
 
 
 
IM 305 Week 3 DQS
 
DQ 1
 
Write a 200- to 300-word short-answer response explaining why a database analyst should not skip the logical database design step and move directly into physical database design.
 
DQ 2
 
 Write a 200- to 300-word short-answer response describing aspects of physical database design that are not found in logical database design.
 
 
 
IM 305 Week 4 Individual Assignment  Additional Elements Paper
 
Write a 3- to 4-page paper outlining the additional elements you would add to the physical model of the reservation system database, developed in Week Three, to incorporate the full meta aspects of modeling.

Format your paper consistent with APA guidelines.
 
 
 
 
 
IM 305 Week 4 DQS
 
DQ 1
 
Write a 200- to 300-word short-answer response describing how modeling techniques can be used by software developers to be converted for use in database design.
 
 
DQ 2
 
Write a 200- to 300-word short-answer response answering the following question: Is meta-modeling a new technique, or is it simply a new name for an old process? Provide details to support your opinion.
 
 
 
 
 
IM 305 Week 5 Learning Team Assignment  Data Modeling Paper
 
Create a 5- to 8-page database management paper by completing the following benchmark assignments: 
Case Tools Paper
Logical and Physical Database Design Paper
Meta-Modeling Paper
Data Warehouse Paper
Format your paper consistent with APA guidelines.
 
 
 
IM 305 Week 5 Learning Team Assignment Data Modeling Presentation
 
Summarize the pertinent information from weekly Learning team efforts for  Data Modeling into a Microsoft(r) PowerPoint(r) presentation. You may include speaker notes or you may embed audio or video in your presentation.
 
IM 305 Week 5 DQS
 
DQ 1
 
Write a 200- to 300-word short-answer response describing how the methodology used in creating a data warehouse differs from the methodology used in the design of an online transaction processing (OLTP) database.
 
 
DQ 2
 
Write a 200- to 300-word short-answer response describing the role normalization plays in the design of a data warehouse.
 

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question