Unit 2 Assignment 1: Homework Learning Objectives and Outcomes Review documents to discover relevant entities and attributes for database. Prepare interview questions and follow up. Prepare questionnaires. Observe work flow for process and exceptions. Identify the issues with the current database. Define and list requirements of a database. Define business rules of a database. Define entities and attributes of a database. Identify candidate keys for entities of a database. Assignment
Words: 687 - Pages: 3
CISN 351: Review Questions Chapter 2 2.1 What is a business intelligence (BI) system? 2.2 What is an ad-hoc query? 2.3 What does SQL stand for, and what is SQL? 2.4 What does SKU stand for? What is an SKU? 2.5 Summarize how data were altered and filtered in creating the Cape Codd data extraction. 2.6 Explain, in general terms, the relationships among the RETAIL_ORDER, ORDER_ITEM, and SKU_DATA tables. 2.7 Summarize the background of SQL. 2.8 What is SQL-92
Words: 7421 - Pages: 30
|[pic] |Course Syllabus | | |College of Information Systems & Technology | | |DBM/380 Version 9 | |
Words: 3236 - Pages: 13
STRAYER UNIVERSITY Enterprise Technology Process Models – CIS 521 Midterm Exam Quarter: May 2007 Instructor: Prof. Mort Anvari (202) 294-4230 Morteza@Anvari.net Class Web Site: http://www.anvari.net 1. How has the modern enterprise architectures changed from the early network solutions of the 1970s? The modern enterprise architectures has changed from the early network solution in that the early solution followed by vertical, hierarchial approach versus the modern
Words: 2453 - Pages: 10
Section A: Multiple Choices: 1. Structured Query Language (SQL) is the language for working with b. RDBMS 2. Decomposition in database design means a. Breaking one table into multiple tables 3. Locking helps b. To solve concurrency problems 4. Database optimizer b. Minimizes the speed of query execution 5. Data is __________. a. Raw facts 6. Mobile computing means d. None of the above 7. Operation Data Store (ODS) provides c. Both (a) & (b) 8. Transaction is c. Logical
Words: 2698 - Pages: 11
Section 1 1. The study of computer based Information Systems (IS) is not just limited to traditional computers and servers, but also includes such devices as: a. Network Routers b. Mobile Phones c. Telecommunication Switches d. All of the Above 2. Information Technology (IT) refers only to the information processing software programs of a computer system: True or False 3. Information Systems are used in the business world to support an organization’s: a. Decision Making b. Business
Words: 1842 - Pages: 8
Relational Database Management Systems TVSN Murthy Assistant Professor – DFT NIFT Hyderabad Disclaimer: These slides are just for the purpose of easy reading and are not comprehensive in nature. Thus the slides have to be read together with the class lectures, reading material, and statutes dealing with the subject RDBMS/Slide 1 Introduction Flat files - 1960s - 1980s Hierarchical – 1970s - 1990s Network – 1970s - 1990s Relational – 1980s – present Object-oriented – 1990s – present Object-relational
Words: 4443 - Pages: 18
and reporting. To use data models and/or server technologies that speed up querying and reporting and that are not appropriate for transaction processing There are ways of modeling data that usually speed up querying and reporting (e.g., a star schema) and may not be appropriate for transaction processing because the modeling technique will slow down and complicate transaction processing. Also, there are server technologies that that may speed up query and reporting processing but may slow down
Words: 1160 - Pages: 5
Database Analysis Paper Daltrin L Wardell University of Phoenix CIS 319 8/30/2010 ABSTRACT Good Sportsman Marketing utilizes several software programs and a database system which is named Navision to operate its daily business. In the following paper I will outline and describe some of the Navision’s strengths as well as some of its weaknesses. Navision is the database management system that Good Sportsman Marketing’s IT personnel chose because of its ability to grow along with the company
Words: 858 - Pages: 4
DATABASE DESIGN AND THE IMPORTANCE OF DESIGNING A FUNCTIONAL PROCESS CIS475 Instructor: IBRAHIM ELHAG, PhD 3/6/2012 DATABASE DESIGN One of the most important if not the most important aspect of a database is the database design process. It is a must that the design is good and functional. A database consists of many different parts of an engineer’s design, which together makes up a complete database system. A database system is designed to manage large bodies
Words: 2041 - Pages: 9
