O designed and built for a specific application o

This preview shows page 9 - 14 out of 14 pages.

o Designed and built for a specific application. o Represents some aspect of the real world. Database Management System (DBMS): o A software system designed to store, manage, and facilitate access to databases.
Image of page 9

Subscribe to view the full document.

10 INTRODUCTION Database Applications : o Banking: all transactions o Airlines: reservations, schedules o Universities: registration, grades o Sales: customers, products, purchases
Image of page 10
11 INTRODUCTION Why DBMSs? o Many database applications deal with large amounts of information o DBMSs provide a set of tools for storing, searching and managing this information in an efficient manner.
Image of page 11

Subscribe to view the full document.

12 INTRODUCTION DBMS examples: o Oracle o DB2 (IBM) o MS SQL Server o MS Access o MySQL o PostgreSQL
Image of page 12
13 INTRODUCTION Data Model : a collection of concepts for describing data. Common data models: o Relational model o Object-oriented model o Object-relational model o Free text model o Semi-structured model (e.g., XML)
Image of page 13

Subscribe to view the full document.

14 INTRODUCTION Example : University Database Data Model: Relational o Students (sid, name, login, major, cgpa) o Courses (cid, cname, credits) o Enrollment (sid, cid, grade)
Image of page 14
You've reached the end of this preview.
  • Spring '10
  • smith
  • Databases, Relational model, Conceptual Database Design

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