CIS 111 Midterm Exam NEW Set 1 • Question 1____ provide(s) a description of the data characteristics and the set of relationships that link the data found within the database. • Question 2 A desktop database is a ____ database. • Question 3 End-user data is ____. • Question ..
CIS 111 Week 11 Final Exam NEW • Question 1 Which query will output the table contents when the value of P_PRICE is less than or equal to 10? • Question 2 The SQL command that lets you select attributes from rows in one or more tables is ____. • Question 3 To list all the contents of the ..
CIS 111 Week 2 Assignment 1 Business Rules and Data Models NEW Assignment 1: Business Rules and Data Models Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and cou..
CIS 111 Week 3 Lab 1 Creating a Database Design in Visio NEW This assignment contains two (2) Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Use “Appendix A: Designing Databases with Visio Professional..
CIS 111 Week 4 Lab 2 Modifying a Database Design in Visio NEW This assignment contains two (2) Sections: Modified Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Use “Appendix A: Designing Databases with Visio Pr..
CIS 111 Week 5 Lab 3 EasyPHP and MySQL Setup NEW • Install EasyPHP and MySQL and take a screen shot that shows the MySQL prompt on your screen. (Note: You must include the screen shot which shows that MySQL is installed on your computer as part of your assignment. An installation guide to aid the..
CIS 111 Week 6 Assignment 2 Normalization NEW Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training session. Write a tw..
CIS 111 Week 7 Lab 4 Structured Query Language (SQL) NEW Refer to the database design crested in Lab 2: Modifying a Database Design in Visio to complete this Lab. Perform the following steps in MySQL: 1. Create the tables and relationships from the database design discussed in Lab..
CIS 111 Week 9 Assignment 3 Business Intelligence and Data Warehouses NEW Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a manner that optimizes processing large amounts of data. &..
Showing 1 to 9 of 9 (1 Pages)