Font size
WorksheetsIM module 1-4
Total questions: 114
Worksheet time: 2hrs 54mins
Raw facts
(a)
changing data
(a)
deleting rows
(a)
adding new rows
(a)
primary a tool
(a)
two relations
(a)
recursive
(a)
natural and familiar
(a)
default primary key
(a)
mandatory side
(a)
new relation
(a)
one side
(a)
separate relation
(a)
component attributes
(a)
map directly
(a)
dependent side to null
(a)
automatically delete
(a)
dont allow delete
(a)
maintain foreign keys
(a)
maintain primary keys
(a)
allowable values
(a)
combination of two or more columns
(a)
allows one null value
(a)
not chosen
(a)
can be simple or composite
(a)
dependent
(a)
exist only in main memory
(a)
actually stored in database
(a)
combination of columns
(a)
no duplicate
(a)
only one value
(a)
no positional concepts
(a)
(tuples)
(a)
(attributes)
(a)
logical structure
(a)
detailed
(a)
requirements
(a)
represent a relationship
(a)
represents a single superclass
(a)
process that defines
(a)
generalizing
(a)
may participate in a relationship unique
(a)
indicate all subtypes will participate
(a)
connection between subclass and superclass
(a)
inherit values
(a)
group with unique attributes
(a)
generic entity
(a)
relationship with one or more subtype
(a)
rectangle with diamond inside
(a)
double line diamond
(a)
dependent
(a)
exist independently
(a)
number of instances
(a)
vice versa and most one entity
(a)
most one entity
(a)
vice-versa
(a)
relationship between an entity and itself
(a)
specifies what it does
(a)
includes N entity types
(a)
includes 3 entity types
(a)
includes two entity types
(a)
could be optional
(a)
associated
(a)
chosen
(a)
minimal
(a)
identifies an entity
(a)
unique
(a)
more than one values
(a)
single value
(a)
do not exist
(a)
more than one simple attributes
(a)
atomic
(a)
exist a domain
(a)
collection
(a)
real world thing
(a)
UML
(a)
crows feet
(a)
named after Dr. peter
(a)
· Provide a way
· Conceptual view
(a)
Logical structures
(a)
E-R models
(a)
User views
(a)
Define database
(a)
System development life cycle
(a)
Covers the collection
(a)
Instructions and rules
(a)
Use application programs to run
(a)
Design and implement
(a)
Manage DBMS
(a)
Oversee
(a)
Includes all user
(a)
Manipulate data
(a)
Manages the database within database system
(a)
Manages all hardware components
(a)
Readily identified
(a)
Physical devices
(a)
Organization of components
(a)
Modification of certain values
(a)
Deletion of values
(a)
Inability to store
(a)
Not required changes
(a)
Same data restored
(a)
Same data appears
(a)
Wide variety
(a)
Cloud services
(a)
Logically
(a)
Single site
(a)
Company data
(a)
50 user
(a)
Multiple
(a)
Single-user
(a)
One user
(a)
Collection of programs manages the database
(a)
Intergrated and managed
(a)
