final exam Flashcards
the benefit of linux is
it’s cheap
a subclass ____ attributes from the superclass
inherits
a stack is
LIFO
In MIS we have to remember that we are always trying to meet the users _____
needs
a good side to redundancy is that it can lead to better ____
- results
- response time
a relationship that has attributes can become a(n) _____ entity
associative
when converting a many-to-many relationship, how many relations will be created
3
partial specialization (incomplete) implies
an instance of the superclass may not belong to a subclass
the overlap constraint states that
an instance of the superclass may belong to multiple subclasses
MySQL is a(n)
relational DBSM
the idea of a DBMS separating the data from the application is
data independence
the concept that a foreign key in one table must have a matching primary key in the connected table is
referential integrity
SQL stands for
structured query language
data dependence can lead to
data redundancy
the number or instances of entity A that may be associated with entity B is the
maximum cardinality
data about the data in the database are stored in the
data dictionary
the goal of database design is to eliminate
redundancy
which of the following is used to ensure data integrity
- default values
- range controls
- referential integrity
- null value controls
which of the following is true about Linux
- it is a version of unix
- it was developed by linus torvalds
- it is essentially free
which statement is more correct?
SQL is embedded in PHP which is embedded in html
the purpose of normalization is to
reduce inconsistency
the number of instances of entity A that must be associated with entity B is the
minimum cardinality
the storage of records in order on a tape or disk by primary key is an example of
sequential file organization
which of the following is used to ensure data integrity
- default values
- range controls
- referential integrity
- null value controls
denormalization is often used to
decrease response time
the layer of coding logic that processes the data for the user in a client server architecture is
the application logic layer
partial specialization (incomplete) implies
an instance of the superclass may not belong to a subclass
the disjoint constraint states that
an instance of the superclass may only belong to one subclass
a client that can handle major database and application processing and has a powerful CPU is probably a(n)
fat client
Linux was developed by
Linus Torvalds
a client server architecture with a server for the DBMS and a separate server for the applications is
3 tierd
unix is
open source
in MIS we have to remember that we are always trying the meet the users
needs?
