1 / 14

Computer Science & Engineering 2111

Computer Science & Engineering 2111. Introduction to Database Systems. Database Terms. Data A collection of numbers and text 273459368 Information Meaning derived from the data SSN: 273-45-9368. What is a database?. A large collection of data stored in a well-defined structure

conley
Download Presentation

Computer Science & Engineering 2111

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. 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

More Related