What are some database models?
Give this one a try later!
, Hierarchical - data organized like upside-down tree; each parent node can
have several children, each child node can have only one parent
Network - Like hierarchical except each child can have several parents
Relational - data stored in tables consisting of rows and columns
Multidimensional - data stored in cubes with three or more dimensions
Object oriented - organized by classes, objects, attributes, and methods
Melody is building a database for a restaurant. Which pair of tables is least likely to
need a direct relationship with each other?
Give this one a try later!
Customers, Ingredients - Relationships in relational databases are created
to show how data in one table is related to data in another table. It's highly
unlikely that a restaurant's database would need to show a relationship
between customers and the ingredients used in items on the menu.
Which field could serve as the primary key for a list of students in your school?
Give this one a try later!
Student ID number - The primary key field(s) must include a unique piece of
information for each record, something that will not be duplicated across
multiple records. Typically, this is a numeric field that contains a unique
number of some kind, such as Student ID number.
All the pet names in a veterinarian's database are stored in a _______ called PetName.
Give this one a try later!
Give this one a try later!
, Hierarchical - data organized like upside-down tree; each parent node can
have several children, each child node can have only one parent
Network - Like hierarchical except each child can have several parents
Relational - data stored in tables consisting of rows and columns
Multidimensional - data stored in cubes with three or more dimensions
Object oriented - organized by classes, objects, attributes, and methods
Melody is building a database for a restaurant. Which pair of tables is least likely to
need a direct relationship with each other?
Give this one a try later!
Customers, Ingredients - Relationships in relational databases are created
to show how data in one table is related to data in another table. It's highly
unlikely that a restaurant's database would need to show a relationship
between customers and the ingredients used in items on the menu.
Which field could serve as the primary key for a list of students in your school?
Give this one a try later!
Student ID number - The primary key field(s) must include a unique piece of
information for each record, something that will not be duplicated across
multiple records. Typically, this is a numeric field that contains a unique
number of some kind, such as Student ID number.
All the pet names in a veterinarian's database are stored in a _______ called PetName.
Give this one a try later!
