IM 300 ENTIRE COURSE


Ask a Question

IM 300 ENTIRE COURSE

Sale price $40.00 Regular price $80.00

IM 300 ENTIRE COURSE

 

IM 300 Week 1 Individual Assignment Sharing Database Knowledge
 
Review the assignment options described in the University of Phoenix Material: Sharing Database Knowledge and follow the instructions.
Option 1: System E-mail – A coworker asks you to share your expertise about standard-relational and object-relational databases.
Option 2: System Executive Summary – Your company asked you for an executive summary sharing your expertise about standard-relational and object-relational databases.
Submit your assignment using the Assignment Files tab above.
 
 
IM 300 Week 2 Individual Assignment Assignment  SR-bi-003 – Hotel Database, Part 1
 
Resources: Virtual Organizations for Baderman Island: SR-bi-003 – Hotel Database
Review SR-bi-003 – Hotel Database. During Weeks 2, 3, and 4 you complete the service request. The Virtual Organizations portal is linked on the course page and from there navigate to the Service Requests.
Identify the primary and foreign keys that you think would work best with the given entities using information from the service request.
Write a memo the senior project manager including the following:
The identified primary and foreign keys.
Justify why you have chosen these keys.
Submit your assignment using the Assignment Files tab above.
 
 
IM 300 Week 2 Individual Assignment SR-bi-003 – Hotel Database, Part 2
 
Resources: Virtual Organizations; SR-bi-003 – Hotel Database and Oracle® Database Express® Virtual Desktop
Create tables and fields for the entities and attributes provided using Oracle® Express®.
Create a DDL script. Go to Utilities > Generate DDL and create a script file with all tables, indices, sequences, and triggers in your database.
Submit your assignment using the Assignment Files tab above.
 
 
 
IM 300 Week 3 Individual  Assignment   SR-bi-003 – Hotel Database, Part 3
 
Resources: SR-bi-003 – Hotel Database, the results from SR-bi-003 – Hotel Database Parts 1 & 2, Oracle® Database Express® and Microsoft® Visio® Virtual Desktop.
Complete Service Request SR-bi-003 - Hotel Database–Part 3.
Normalize the entities and attributes to at least the third normal form.
Use Microsoft® Visio® diagramming tools to create an entity-relationship diagram (ERD) that demonstrates the logical design of your normalized database.
Create and alter tables in the city’s Oracle® Database Express® database to implement the ERD design.
Generate a new DDL script.
Create a fax cover sheet addressed to the project manager for the ERD and a newly generated DDL script to show your progress on the project.
Submit your assignment using the Assignment Files tab above.
 
 
IM 300 Week 4 Individual Assignment SR-bi-003 – Hotel Database, Part 4
 
Resources: SR-bi-003 – Hotel Database, the results from SR-bi-003 – Hotel Database Part 3, and Oracle® Database Express® Virtual Desktop
Complete the service request byimplementing referential integrity and constraints in your database:
Create an AFTER trigger on the Hotel table that deletes any records from the Rooms table that match (:old.HOTEL_ID).
Apply at least six constraints within the database.
Create a newly generated DDL script.
Create a fax cover sheet addressed to the project manager for the referential integrity and constraints work you have completed and include a newly generated DDL script to show your progress on the project.
Submit your assignment using the Assignment Files tab above.
 
 
IM 300 Week 5 Learning Team Assignment   Database Management Paper
 
Finalize and submit your Database Management paper.
 
IM 300 Week 5 Learning Team Database Management Presentation
 
Finalize and submit your Database Management presentation.
 
IM 300 Week 5  Individual Assignment Career Opportunities
 
Write a 1- to 2-page paper discussing what professional organizations you might join, and what websites you might visit that would provide insight into a career that includes responsibilitiy for data organization architecture.
Submit your assignment using the Assignment Files tab above.
 
 

Questions & Answers

Have a Question?

Be the first to ask a question about this.

Ask a Question