Module 2 Unit 4 Flashcards
what are the structural elements of a database table?
Each table stores information about records (rows in the table) in fields (columns in the tables).
what term is used to describe selecting and viewing information in a database?
Query
how does an RDBMS such as Microsoft SQL server differ from Microsoft Excel when used to store a data set?
Excel is an example of a flat file system. They usually support a single user only, and do not scale well.
RDBMS platforms enable many hundreds or thousands of users to connect concurrent and can support very large data sets. It can also validate information entered in fields and records
what language is usually used to request data from an RDBMS such as Oracle?
structured query language, also known as SQL it is used to query RDBMS based data platforms
what is it that defines the relationship between tables in an RDBMS?
each table contains a primary key, whose value is unique for each record in the table. A foreign table can use the value of a primary key as a relation storing the value in a foreign key field.
give an example of unstructured data.
Images and text files and other document formats are unstructured data
give two examples of semi structured data stores
Key/value pair databases and markup language document stores
is an INSERT statement an example of a definition or manipulation language state
manipulation language
why? because it depends on the structure of a table being established already
you need a development environment with a library of database functions. what type of interface are you using?
Programmatic access
How can a client-server application architect be described if there is the potential for the structure of the application platform to be developed further?
this could be described as a two-tier application.
It could be developed as a three tier application by specifying presentation, application and data layers
