MIS 325- Midterm Exam Guide - Comprehensive Notes for the exam ( 28 pages long!)

• School: UT-Austin
• Department: Management Information Systems
• Course: MIS 325
• Professor: J Mote

Document Summary

Mis 325 database environment intro 1. 1. Why do we keep data? to support different functions: better customer service, catch issues if you see a bad trend, look for ways to improve it, support decision making, managerial decision making is key. How to record data: example: you want to keep track of things that happen in a car shop. See example in slides 1/18/18: you should collect, customer name, car, type of car, how many cars come to shop in one day, what services are provided/how many per day, storage potentials not good. Sql: structured query language, used to create and manipulate databases, nonprocedural access, query: request for data to answer a question, sql select statement and graphical tools. Indicate what parts of database to retrieve not the procedural details. Application development form: formatted document for data entry and display report: formatted document for display: use nonprocedural access to specify data requirements of forms and reports.