Introduction to database

Chapter 7: Database Applications and Privacy Implications

Database- is a collection of information that has been organized in a certain way or a storage container for data. or a collection of info stored on computer disks.

-Making it easy to reference and retrieve

-Example:telephone book-combination of first name and last, receipe cards..

What is a unique identifier?

It is a combination of databases.

Google was launched by Sergey Brin and Larry Page.

Database Software: an application that is designed to maintain databases.

Computerized databases make it easier to store large amounts of info, retrieve info quickly and flexibly,

Database program: a software tool for organizing the storage and retrieval of info

Database: a collection of info stored in an organized form in a computer. Composed of one or more tables, A table is a collection of related info and/or records.

What is a record?

A record is the information relating to one person, product, or event.

Each discrete

The type of info the field can hold is told by its Field type or Data Type.

Database programs allow you to view in:

Form view-show one record at a time.

List view-display several records in lists similar to the way a spreadsheet displays data.

In views, fields can be rearranged without changing the data.

What are Database Operations?

Import: receive data in the form of text files

Browse: navigate through info

Query: find records that match specfic criteria.

Sort: rearrange records.

Print reports, labels, and form letters: A report is an ordered list of selected records and fields in an easy to read format.

What does SQL stand for?

Structured Query Language

-Is a standard language

-Is available for many database management systems

-Allows point and click queries that insulate users from the complexieies of the query language.

Specialized database software: preprogrammed for spefic data storage and retrieveal purposes.

Geographical

Persinal info manager(PIM): an electronic organizer.Functions: -address book, Appointment calendar, to-do list, miscellaneous notes

-Handheld computers can share info with apps such as iCalendar running on PCs an Macintoshes.

File Manager: enables users to work with one file at a time.

Database Management system(DBMS): manipulates data in a large collection of files, cross-referencing between files as needed.

-can be used interactively or controlled by other programs.

Relational database: program is one that allows tables to be related to each other.

-Changes in lne table are reflected in other tables automatically.

To computer scientists, relational database has a technical definition related to:

The underlying structure data

The rules specifying how that data can be manipulated.