Computer Science & Engineering 2111

1. Computer Science & Engineering 2111 Introduction to Database Systems CSE 2111-Introduction to Database Systems

2. Database Terms • Data • A collection of numbers and text • 273459368 • Information • Meaning derived from the data • SSN: 273-45-9368 CSE 2111-Introduction to Database Systems

3. What is a database? • A large collection of data stored in a well-defined structure • You can think of a database as • An electronic filing system • A repository for large amounts of information • Example of a paper database • Telephone book • Examples of computer databases • Ohio State stores student information in a database • Insurance companies store policy holder information in a database • Your employer stores your information in a database CSE 2111-Introduction to Database Systems

4. Database Software • How do I create a database? • Purchase the software • We will use MS Access 2010, but there are many database software products • Oracle • Sybase • SQL Server • How do I access information in the database? • Purchase a Database Management System (DBMS) • A DBMS is a collection of programs that enable you to enter, organize, and select data in a database. • We will use MS Access 2010, but there are many database management software products CSE 2111-Introduction to Database Systems

5. Steps when setting up a Database • The design should be initially created schematically, and then the database should be created using the chosen database software CSE 2111-Introduction to Database Systems

6. 1. Decide what information you will store in the database This database is a very simplistic one. Most databases you create will be much more complex. Research Papers database CSE 2111-Introduction to Database Systems

7. 2. Create the layout of the database • What tables do you need in your database? • What is a table? • An entity used to organize information by categories of like information CSE 2111-Introduction to Database Systems

8. Research Papers Database Tables • Client • Stores client information • Charges • Stores client charges information • Payments • Stores client payment information • PaymentMethod • Stores the payment method • Credit Card • Cash • Check CSE 2111-Introduction to Database Systems

9. 2. Create the layout of the database • What fields do you need in your database? • What is a field? • An attribute (piece of information) of the table/entity. • How will you set them up? • Divide Tables into Inseparable Fields • Address as 1 field – • 17 Main St. New York, New York 10002 • Address as 4 fields • Street Address - 17 Main St. • City - New York • State - New York • Zip code – 10002 CSE 2111-Introduction to Database Systems

10. Research Papers Database CSE 2111-Introduction to Database Systems

11. 2. Create the layout of the database • Fields contain field types/data types and field properties • What is a field Type/Data Type? • Defines the type of information that can be stored. i.e. text, numbers, dates, etc. • What is a field Property? • Field size • Input Mask • Validity • Default Value CSE 2111-Introduction to Database Systems

12. Research Papers Database CSE 2111-Introduction to Database Systems

13. 2. Create the layout of the database • What will be the primary key for each table? • A field, or a collection of fields, whose values uniquely identify each record in a table CSE 2111-Introduction to Database Systems

14. Research Papers Database CSE 2111-Introduction to Database Systems