1 / 17

INLS 623– Database Systems II

INLS 623– Database Systems II. Instructor: Dr. Carter. Database Management System. Database: Logically Coherent Collection of related data. Types of Database Systems. Relational Graph Object-oriented. Relational Database Systems in Wide Use.

dino
Download Presentation

INLS 623– Database Systems II

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. INLS 623– Database Systems II Instructor: Dr. Carter

  2. Database Management System • Database: Logically Coherent Collection of related data

  3. Types of Database Systems • Relational • Graph • Object-oriented

  4. Relational Database Systems in Wide Use • Three Major Database Management Systems in wide use • Oracle - Large, commercial, enterprise-scale, very verytweakable • MySql - Simpler but very fast and scalable - commercial open source • SqlServer - Very nice - from Microsoft (also Access) • Postgres – Open source, enterprise scale • SQLite – Very small, mostly used for one user

  5. Relational Database • Review • What is an Entity? An object of interest with properties or attributes Give some examples of entities? University domain: student, lecturer, course, grade, room, facility, year-of-study, major, department, …

  6. Entities Have Properties • Properties have types • Types: number, string, blob In a relationalDBMS, how do we represent entities?

  7. Represent Entities as Tables • Store data in rows and columns • All tables have a name • Each column in the table has: • A name (property) • A type • Each row is a record • Records contain the data

  8. Tables Columns Table Name: People Rows Tables can be related to one another

  9. Relationships • A constraint between two entities • Examples? • Each student has one grade per course • A student can take multiple courses • Types of relationships • one-to-one • many-to-one • many-to-many

  10. Types of Relationships

  11. Keys: More Constraints • Primary Key • Secondary Key(s) • Candidate Key(s) • Foreign Key(s)

  12. Primary Key Constraint • Uniquely identifies each record in a database table. • Primary keys must contain unique values. • A primary key column cannot contain NULL values. • Most tables should have a primary key, and each table can have only ONE primary key.

  13. Secondary and Candidate Keys • Sometimes there are more than one key for a relation. • Database Administrator chooses the primary key. • The other keys are called secondary keys. • The secondary and primary keys are called candidate keys.

  14. Foreign Keys • Capture relationships across entities(tables). • A FOREIGN KEY in one table points to a PRIMARY KEY in another table.

  15. Topics We will Cover • Review • Database Design • Normal Form • Database Indexing • Database Tuning • Triggers • XML • Database development on the Internet • Non-relational databases

  16. Mysql • Mysql • http://dev.mysql.com/downloads/ • MySQL Community Server • Mysql Workbench • Visual tool to manager mysql databases • http://dev.mysql.com/downloads/workbench/

  17. Resources • http://www.w3schools.com/sql/

More Related