Database terms
Use short answers and examples to explain the following: An Operational database collects and stores data that is updated dynamically. This type of database is modified on regular intervals. A database containing account records for customers of a financial institution is an example of an operational database. This database is modified as customers change account information by performing various transactions at different intervals. An Analytical database is used to store data collected at a specific time. The data in this type of database remains constant and almost never changes. Companies conducting surveys or performing research often use this type of database. A marketing company conducting surveys on customer's evaluation of a specific product would use an analytical
Each table is made up of records (horizontal rows, known as tuples) and fields (vertical columns, known as attributes). Name Age SexBarton 35 MShows 24 FMays 48 F PersonsName Cars OwnedBarton Honda 4Mays Toyota 2Shows Dodge 1Mays Nissan 3 Cars OwnedMission Statement A database mission statement defines the purpose of the database in general terms. The following statement is an example of a database mission objective:" Information Solutions Inc. The best way to visualize this type of database model is to visualize an upside down tree of data. To reach a lower-level table you must start at the root and work your way down through the tree structure to the desired target. A child table has only one parent whereas a parent table can have many children. At the core of this database model is the concept of a table (also called a relation) in which all data is stored. The following diagram shows and example of a network database model:Relational Database Model (D1, D2) The relational database model is a particular kind of database that is based on the structures and mathematics of relations. A user just needs to know the name of the table in order to use it and does not have to be concerned about the structure of the data within the table. How and where the tables of data are stored has little significance. In fact, the hierarchical database model is a subset of the network model. Thus, children can have multiple parents and parents can have multiple children. Likewise the order of columns is not important since they are labeled with attributes. The following diagram shows an example of a hierarchical database model: Network Database Model (D1) The network database model is very similar to the hierarchical database model. Relationships in a hierarchical database model are thought of in terms of parents and children.
Common topics in this essay:
Model D1,
D1 D2,
Database Operational,
Database Analytical,
database model,
Mission Statement,
Mission Objective,
Database Model,
Solutions Inc,
hierarchical database,
hierarchical database model,
,
network database,
Sex Barton,
network database model,
relational database model,
mission statement,
relational database,
analytical database,
operational database,
database mission,
type database,
database model d1,
mission objective,
database model ·,
|
Acceptance Essays
