k201 lecture test

Last update by dksskrm on 03/28/2013
60691 People have viewed this Quiz
  • Share

in a relational database model, a person, place, thing, transaction, or event about which info is stored

Answer:
Entity

View k201 lecture test as Flashcard Deck

Related Quiz Content
  • jamiepares
    Answered in k201 lecture test
    also called fields or colums are characteristics or properties of an entity class
    Attributes
  • jamiepares
    Answered in k201 lecture test
    a field (or group of fields) that uniquely identifies a given entity in a table
    Primary Key
  • jamiepares
    Answered in k201 lecture test
    the relational database model is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship b/w the two tables
    Foreign key
  • jamiepares
    Answered in k201 lecture test
    deals with the physical storage of info on a storage device such as a hard disk
    Physical view
  • jamiepares
    Answered in k201 lecture test
    the duplication of info or storing the same info in multiple places
    Redundancy
  • jamiepares
    Answered in k201 lecture test
    a measure of the quality of info
    Information Integrity
  • jamiepares
    Answered in k201 lecture test
    rules that help ensure the quality of info
    Integrity contraints
  • jamiepares
    Answered in k201 lecture test
    rules that enforce basic and fundamental info-based constraints
    Relational integrity constraints
  • jamiepares
    Answered in k201 lecture test
    enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints
    Business-critical integrity constraints
  • jamiepares
    Answered in k201 lecture test
    software through which users and application programs interact with a database
    Database management system (DBMS)
  • jamiepares
    Answered in k201 lecture test
    an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database
    Data-driven website