database management Flashcards
how is data stored?
data is stored in files that contains records, and in turn contain fields
what is a database
is a collection of data or information which is stored in a logical and structured way
other names of a database software?
-Database manager
-Database management system (DBMS
what is database software used for?
store, organise and manipulate data
what does data manipulation include
-adding new data
-deleting old data (which is not necessary to store any longer)
-updating data/information
why do we need a database
-To keep records of customers, staffs, products, etc.
-To develop reports
-To perform research
For longitudinal tracking
examples of non computerised database
dictionary, telephone directory, address book
(printed)
examples of computerised database
Netflix, phone contacts, game library, Facebook
electronic
how is Netflix a database
- it stores movies/films in a datbase
-easily searched and sorted
-can search by genre, rating, age
-can sort by release date, takings
how is your phone contacts a database
- all info about contacts are stored in a database on the phone
- can store pictures, names, numbers, emails
easily searched and sorted
some common areas of using database applications
banking (transactions)
airlines (reservations/schedules)
universities(registration, grades)
popular database software
oracle, microsoft SQL, mySQL, microsoft access
name 3 data models
relational mode, hierarchal model, object-oriented model
what is the relational database model
A data store designed in an organised way, making it easier to search for the information you need.
entities and relationships are stored in tables
what is a record in relational database model?
A Relational Database is a collection of tables that are related to one another based on a common field
Each line or row in a table is called a Record
what is the primary key in relational database model?
Each record should have a field which is unique in every record and this field is called Primary Key
such as id number of student
what is a foreign key in relational database model
The Primary Key of one entity is a Foreign Key in another entity
what are the fields of an entity in a relational database model
The fields of an Entity are column headings in a table and each field has a particular data type such as customer_Id is a text type data and order-date is a date type data
what is a query in a relational database model
If we want to find some particular records from a number of records, we need to run a query
what is a data model?
A data model attempts to represent the data requirements of the organisation
-describing data
-relationships between data
-constraints on the data used by an organisation
what is the purpose of a data model?
The purpose of data model is to represent data and to make sure the data is understandable. If it does this, then it can be used to design a database.
One of data model is known as Relational model
what are the structural components of relational models
field (attribute) - a named column of a relation
Record (Tuple) - A row of a relation
file (relation) - A table with columns and rows
Domain - Range of allowable values for one or more attributes
relational database - A collection of tables that are related to one another based on a common field
relational model in terms of university students
some info uni keeps of a student : id number, name, address, number, gender, nationality, DOB
each of these is 1 piece of information, this is called a field
all of the fields put together to make a record (all data about 1 person in a table)
all records are stored together in a file
a file consists of a collection of particular records
why is the domain concept important
The domain concept is important because it allows us to define the meaning and source of values that attributes can hold.
As a result, more information is available to the system and can reject operations that do not make sense