User Account

All Pages

What would be affected by a change in business policy

Assignment Help Management Information Sys
Reference no: EM131768855

Lab -Groupish

This week's lab has 2 parts. Part 1 - Asking the database questions, Part 2 - Change management

Part 1 will have a group submission box

Part 2 will be individual

For both labs you will be working with the same system.

Asking the database questions

Purpose

The purpose of this assignment is to get you used to select statements in a way that allows you to make the connection between asking questions that are relevant to your users and query structure.

Overview of lab

You will be making a small database based off a script on Blackboard.  Before you run the script check it out.  What is it doing? 

What you need to do

-  Open the script in Blackboard

-  Look at it, what is it doing etc...  draw an ERD diagram and a database schema that shows the tables, how they are related, and the attributes of the relation as well as their datatypes.

Then, answer the following questions by querying the database using "SELECT" statements.Each group member should "own" one or more of these queries....your grade will be determined by the queries you "own." This is a group-ish project because you are allowed to work together on the queries. Your grade will be determined by the quality of the queries you "own"

-  What courses, if any, have never been taken

-  What courses are the most popular...meaning they've been taken the most times

-  Which courses are held in the same room?

-  Query the database so it shows who to contact (Department.admin) for each course

-  Show the top three students with the highest grades in the database in DESC order

-  Who has worked at the college for the longest amount of time?

-  Who has worked at the college for the shortest amount of time?

-  Courses with no instructors

- Courses with two instructors

- Three queries (similar to the ones we did in class....hint) that involve subqueries

Deliverables

- Documentation of your system (however you want to do this)

o Entity relationship Diagram

o Database Schema

- Tell me which of your group member's azure instance your database is on and I will look at it

- Your Script in one.txt documents

o   Queries

Should be the queries for the system

- A document FROM EACH GROUP MEMBER outlining which queries they "own" and the decisions they made regarding that query

Delivered Item

Percentage of Grade

12 queries - equally weighted

90%

Documentation

10%

Total

100%

Change Management

Overview:

This portion of the Lab is individual. You will be coming up with a change management plan for the data in the section above. 

Using the system above...

-  Fill out the change management template. You may "make up" information as long as it fits in and makes sense

Turn in a document answering the following questions:

-  Are there any changes that you might anticipate/be proactive about in a student registration system?

-  What would be affected by a change in business policy that each department must now have TWO department admins? Assume you have implemented all of the reports above for the registrar's office.

Delivered Item

Percentage of Grade

Change Management Template

70%

Other Document

30%

Total

100%

Reference no: EM131768855

Questions Cloud

Discuss the basics of financial statement analysis : The purpose of this assignment is to help you understand the basics of financial statement analysis using financial ratios on the assets section of the balance
Compute the predetermined manufacturing overhead rate : Regal Company produces hospital uniforms. Compute the predetermined manufacturing overhead rate. Post actual and allocated manufacturing overhead
Where is your configuration for the routing protocol : What routing protocol did you chose and why? Where is your configuration for the routing protocol? Where is your summarization configuration?
Define evidence of a contract of carriage : Identify the following instruments: a. A written promise by a bank to repay money received from a depositor. b. A written promise to pay another a certain.
What would be affected by a change in business policy : The purpose of this assignment is to get you used to select statements in a way that allows you to make the connection between asking questions.
Determine instrument negotiable or non-negotiable : The following instrument was written on a luncheonette napkin: "I, the undersigned, do acknowledge that I owe Vladimir Lenin ten thousand rubles.
Discuss merchandise each year at double the purchase price : Sold all of the merchandise each year at double the purchase price, with the following collections of cash
Identify an open market operation : Identify an open market operation they might use to increase the money supply.
Effects of the clauses on the negotiability of the note : "The maker of this promissory note hereby reserves the right to extend the time of payment for six months; and the holder reserves the right to extend.

Reviews

Write a Review

Management Information Sys Questions & Answers

  Compare and contrast two natural disasters

Compare and contrast two natural disasters. Provide examples on how they are similar and different regarding early detection, mitigation, preparedness, response and recovery.

  Discuss your feelings about web browser privacy

Discuss your feelings about web browser privacy after reviewing the video Tracking the Trackers at http://www.youtube.com/watch?v=f_f5wNw-2c0 and the information on Collusion & Ghostery at http://www.ghostery.com/.

  Present a detailed proposal of your recommendations

In your proposal please recommend categories of countermeasures and the associated risks that the countermeasures mitigate.

  How does dhl differentiate itself from its competitors

How does DHL differentiate itself from its competitors? How do the morning operations differ from the afternoon operations at DHL's Miami gateway?

  Construct josephs decision tree

Joseph Biggs owns his own ice cream truck and lives 30 miles from a Florida beach resort. - Construct Joseph's decision tree. -  What decision is recommended by the expected value criterion?

  Crm and erphow can a sales department use crm to improve

crm and erphow can a sales department use crm to improve operations?how can a marketing department use crm to improve

  Bad grammar in advertising

Use an search engine on the Internet to find examples of images or Web sites with images of bad grammar used in advertising, company Web sites, or news articles. For example, you can search "bad grammar in advertising" or "bad grammar examples"

  Explain how does data leakage occur in an organization

The focus of the research paper is Data Leakage. How does data leakage occur in an organization? What are the common causes of this problem? How would use address this troublesome trend?

  Explain how it is possible for someone at minitrex to call

Explain how it is possible for someone at Minitrex to call a customer and not know (a) that this is a customer and (b) that this is the third time this week that they had been called?

  Analyze the need for waterfall and agile methodologies

Explain the advantages of extreme programming (XP) and analyze the advantages of its application in high-budget short-time projects.

  Which were most difficult to specify in terms of a scenario

Stimulus. The stimulus is a condition that needs to be considered when it arrives at a system.

  What is the relation between hspa wimax and lte

A research paper on Wireless 4G. It should be a technical paper and must include the following materials: What are some of the technologies involved with the 4G spec and What is the relation between HSPA+, WIMAX and LTE?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd