Tag: architecture

a key that contains only a single field

a key field

a numerical field

a single valued field

replace relational design

be close to a users perception of the data

enable detailed descriptions of data query processing

enable low level descriptions of data

Join

View

Field

Table

Tuple

that a student can own 0, 1 or many cars

a car can be owned by many students

a student cannot own a car

a stundent can own many cars and a car can be owned by many students

An ER model is concerned primarily with a physical implementation of the data and secondly with a logical view

An ER model provides a view of the logic of the data and not the physical implementation

An ER model is concerned primarily with a logical view of the data and secondly with the physical implementation

An ER model is entirely concerned with modelling the physical implementation

an attribute of an entity

a special type of relation

a particular occurance of an entity (e.g. Tom Osman is an instance of the entity STUDENT)

any particular entity

another name for the key linking different tables in a database

another name for a table in an RDBMS

an attribute attached to a record

a row or record in a database table

is achieved using an information flow digram

uses a dataflow diagram

is necessary to remove database anomalies through normalization

is the same as process modelling

is all of the above

system planning and selection

systems design

systems analysis

systems implementation and operation

systems evaluation

top-down approach

bottom-up approach

overview approach

business approach

conceptual approach