Nii performing pairwise comparisons of criteria in

Info icon This preview shows pages 3–7. Sign up to view the full content.

n.ii. Performing pairwise comparisons of criteria in context of goal. n.iii. Performing pairwise comparisons of alternatives in context of criteria.
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

College of Business Administration BUSMIS 1060: Introduction to IS Midterm Exam Review Sheet n.iv. See reading, lecture, and cheat sheet 6. Using Microsoft Access and SQL to extract data from a database a. Concepts a.i. Tables/Relations a.ii. Fields/Columns/Attributes a.iii. Records/Rows/Tuples a.iv. Data Types a.v. Primary Key a.vi. Foreign Key a.vii. Relationship a.viii. Query a.ix. Entity Table a.x. Relationship Table a.xi. Type Table a.xii. RDBMS Underlay TPS a.xiii. Schema a.xiv. Integrity Constraints a.xv. Data Dictionary a.xvi. CRUD a.xvii. See lecture Relational Databases 1 and Chapter 5. b. Basic Skills b.i. Choose all fields and all rows from one table. b.ii. Choose select fields and all rows from one table. b.iii. Choose all fields and only rows where one criterion is true from one table. b.iv. Choose select fields and only rows where one criterion is true . b.v. See lecture Relational Databases 2 and workshop (to be provided) and tutorials. c. Intermediate Skills c.i. Choose select fields and only rows where more than one criteria is true . c.ii. Choose select fields and all rows from two tables . c.iii. Choose select fields from two tables and only fused c.iv. (i.e., joined) rows where one criterion is true . c.v. Choose select fields from two tables and only fused c.vi. (i.e., joined) rows where more than one criteria is true . c.vii. See lecture Relational Databases 2 and workshop (to be provided) and tutorials. d. Advanced Skills d.i. Choose select fields from two tables and only fused d.ii. (i.e., joined) rows where more than one criteria is true , and summarize a field’s values. d.iii. Choose select fields from two tables and only fused d.iv. (i.e., joined) rows where more than one criteria is true , and develop a calculated field. d.v. Choose particular fields and rows from a query using another query. d.vi. Choose particular fields and rows from a query and a table using another query. d.vii. See lecture Relational Databases 2 and workshop (to be provided) and tutorials. 7. Storing and Organizing Information (Chapter 5) a. Overview of Relational Databases
Image of page 4
College of Business Administration BUSMIS 1060: Introduction to IS Midterm Exam Review Sheet b. Databases vs. Spreadsheets c. Relational Databases d. Database Diagrams e. Glossary e.i. legacy systems e.ii. process e.iii. process modeling
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

College of Business Administration BUSMIS 1060: Introduction to IS Midterm Exam Review Sheet Attendance Questions & Answers
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '09
  • ROBBINS
  • Management, Business process modeling, College of Business Administration

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern