Premium Essay

Asdasasa

In:

Submitted By stinx72
Words 570
Pages 3
The Characteristics of Databases
• The purpose of a database is to help people track things of interest to them. • Data is stored in tables, which have rows and columns like a spreadsheet. A database may have multiple tables, where each table stores data about a different thing. • Each row in a table stores data about an occurrence or instance of the thing of interest. • A database stores data and relationships.
KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-1

Data in Tables

KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall

1-2

The Key Characteristic of Databases: Related Tables

KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall

1-3

Database Applications

KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall

1-4

Database Applications—Forms

KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall

1-5

Database Applications—Queries
SELECT FROM WHERE LastName, FirstName, EmailAddress STUDENT StudentNumber > 2;

KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall

1-6

Database—Reports

KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall

1-7

The DBMS

KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall

1-8

The Database
• A database is a self-describing collection of integrated tables. • The tables are called integrated because they store data about the relationships between the rows of data. • A database is called self-describing because it stores a description of itself. • The self-describing data is called metadata, which is data about data.
KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-9

Typical Metadata

Similar Documents

Premium Essay

Asdasasa

...Diary 1 Name: Hew Chen Shen ID: 00005273 Date: June 16, 2014 In my last semester, I have much appreciate in the previous semester and this semester I will have more time to done my own assignment and no need do at last minutes because I just take third subject which is ENG115, BM2010 and BM2007. In ENG115 I have learn a lot of thing but it just remind what we learn in the ENG112-ENG114, after that we being to separate to our tutorial class and my tutor is Mrs Weng. In the tutorial class we will choose the topic and Mrs Weng also have give some example to us choose. In the class, the thought of the VIVA certainly scares me because Sir tell us in one class minimum one people will go for the VIVA so I think I will be selected to be viva caused I think like that because my class only have 7 people only and also I quite lazy in study. In the 2000 word essay, I decided to choose technology as my subject because I have interesting in the topic and also in ENG112-ENG114 I also doing the same topic so I have certainly idea in my brain. In the topic, I also can refer to pervious ENG to do research to get some background information of what I will be working on. In third tutorial class, I learnt how to do a thesis and submitted my topic to Mrs.Weng and he also teach us how to evaluate the topic is too board or too controversial. In the same time, he also print out the check list for let us to check exchange topic to help our friend to check either the topic is suitable be a 2000...

Words: 364 - Pages: 2