C192 Completed Study Guide.pdf - C192 Study Guide by Lesson...

This preview shows 1 out of 14 pages.

C192 - Study Guide by Lesson Updated 02/09/2017 Instructions : Key : Section 1.6 1.6 1.5 1.5 2.1 2.1 2.1 2.1 2.2 2.2 2.3 2.3 2.3 2.3 2.4 2.4 4.4 4.4 Online 5.1 5.1
Image of page 1

Subscribe to view the full document.

C192 - Study Guide by Lesson Updated 02/09/2017 5.1 5.1 6.1.1 6.1.1 6.3.1 6.3.1 6.3.1 6.3.1 6.3.2 6.3.2 6.3.3 6.3.3 Online 6.3.4 6.3.4 6.3.7 6.3.7 6.3.10 6.3.10 ? ? 7.1
Image of page 2
C192 - Study Guide by Lesson Updated 02/09/2017 7.1 7.1 7.1 7.1 7.1 7.1 7.1 7.1 7.2.2-7.2.5 7.2.2 7.2.2 ? 7.3.1 7.3.1 7.3.1 ? 7.3.2-7.3.4 7.3.2 7.3.3 7.3.4 7.3.5-7.3.6 7.3.5 7.3.6 ? 7.4
Image of page 3

Subscribe to view the full document.

C192 - Study Guide by Lesson Updated 02/09/2017 7.4.1 7.4.2 ? 7.4 7.4.7 7.6 7.6.1 7.6.2 8.2 8.2 8.2 8.2 8.2 8.2 8.3 8.3 8.2-8.3 8.2 8.2 8.3 12 ? 12.1 12.2 12.2.1 12.2.2 12.3.1
Image of page 4
C192 - Study Guide by Lesson Updated 02/09/2017 12.3.1 12.3.2 12.3.2 12.3.3 12.4 12.4 12.6 12.6.5 12.6.5 12.7.1 12.7.2 12.7.1-12.7.2 13 13 13 ? 13.1.1 13.1.1 13.1.3 13.1.3 13.1.4 13.1.5 13.1.5 13.1.6 13.1.6 13.2 13.2 13.3
Image of page 5

Subscribe to view the full document.

C192 - Study Guide by Lesson Updated 02/09/2017 13.3 13.3 16 16 (intro section 16 16.2 16.2 16 16.1 16.1.2 16 16.1.2 16.1.1 17 17 ? 17 ? 17 ? 17.1 18
Image of page 6
C192 - Study Guide by Lesson Updated 02/09/2017 18.3 18 ? ? 20.4 ? 20.2.2 20.2.2 20.2.2 20.2.6 20.2.6 20.2.6 20.2.2 20.2.2 20.2.2 20.2.2 20.2.1? ? 20.2.4 20.2.4 20.2.6 20.2.6 22.1 22.1 22.1 22.1.1
Image of page 7

Subscribe to view the full document.

C192 - Study Guide by Lesson Updated 02/09/2017 22.2 22.2 22.2.2 22.2.2 22.2.2 22.2.2 22.2.2-22.2.4 22.2.2 22.2.3 22.2.4 22.2.3 22.2.3 22.2.3 22.2.4 22.2.4 22.2.4 22.2.4 22.2.4 22.2.5 22.2.5 22.2.5 22.2.5 22.2.7 22.2.7 22.3 22.3 22.3 22.3 22.3
Image of page 8
C192 - Study Guide by Lesson Updated 02/09/2017 22.3 22.2.2 22.2.2 22.2.7 22.2.7 23.1 23.1 23.1 23.4 23.4 24 24.1.1 24.1.1 24.1.1 24.1.1 24.1.1 26.2.4 Online 26.2 ? 26 26.1 26.1 26.1 26.4 29 29
Image of page 9

Subscribe to view the full document.

C192 - Study Guide by Lesson Updated 02/09/2017 30.2 30.2 30.5 30.2 31.1-31.4 31.1.2 31.1.3 31.1.4 31.3.4 31.1.5 31.1.5 31.1.5, 31.4 31.7 31.7 31.4 31.4 32.4 32.4
Image of page 10
C192 - Study Guide by Lesson Updated 02/09/2017 32.4 32.4 32.4 32.5 32.4 32.4.1 32.4.1 32.4 33 33.1 33 33.1 33.3.1 33.3.1 33.3.3 33.1 34.1 34.1 34.2 34.1 ? ? 34.1 34.2
Image of page 11

Subscribe to view the full document.

C192 - Study Guide by Lesson Updated 02/09/2017
Image of page 12
C192 - Study Guide by Lesson Updated 02/09/2017 C192 - Study Guide by Lesson Skip Lessons: 3, 9, 10, 11, 14, 15, 19, 21, 25, 27, 28 Cells in this color contain questions/prompts that were provided by the Course Instructors. Cells in this color contain questions/prompts that I deemed important. Cells in this color contain answers to the questions/prompts. Lesson / Objectives Lesson 1: Introduction to Databases Identify strengths and weakness of a DBMS Strengths: > Control of data redundancy and consistency. > Improved security and integrity via the enforcement of standards > Increased productivity via im responsiveness. Weaknesses: > Complexity > Size > Cost > Risk of failure List the three generations of DBMSs. What are the three generations of DBMSs? 1. Hierarchical model (where DBs follow a hierarchical structure) 2. Network model (where DBs have a web-like s Relational model (what we have now) Lesson 2: Database Environment Explain the three level ANSI-SPARC Architecture. What are the 3 levels? 1. External level (the views of the DB / the part of the DB that is relevant to each user) 2. Conceptual level (what data is stored) 3. Inte Explain Logical data independence and Physical data independence. Logical data independence: The immunity of the external schemas to changes in the conceptual schema. (In other words: changing data doesn’t break views) immunity of the conceptual schema to changes in the internal schema. (In other words: changing how data is stored doesn’t change the data itself) What are DDL and DML? How are they different?
Image of page 13

Subscribe to view the full document.

Image of page 14
You've reached the end of this preview.
  • Spring '16
  • Database management system, Study Guide

{[ 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