1. What is a Database?
The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique or it can be generated by the DBMS
2. What are the 4 components of an organizational system?
1. Task
2. People
3. Structure
4. Technology
3. Briefly describe the functions of client/server web architect?
A network architecture in which each computer or process on the network is either a client or a server. Servers are powerful computers or processes dedicated to managing disk drives (file servers), printers (print servers), or network traffic (network servers ). Clients are PCs or workstations on which users run applications. Clients rely on servers for resources, such as files, devices, and even processing power.
4. What Is an entity?
an entity is a single person, place, or thing about which data can be stored.
5. What is business logic?
Business logic, or domain logic, is a non-technical term generally used to describe the functional algorithms that handle information exchange between a database and a user interface.
6. What is a relational database?
A relational database is a collection of data items organized as a set of formally described tables from which data can be accessed easily
7. What purpose does a primary key serve in a table?
A key is used to identify a row in a database table. When used as a primary key then the value contained it must be unique in that table - no other row can have the same value.
8. What is a Table?
In relational databases and flat file databases, a table is a set of data elements values that is organized using a model of vertical columns which are identified by their name and horizontal rows, the cell being the unit where a row and column intersect. A table has a specified number of columns, but can have any number of rows citation needed. Each row is identified by the values appearing in...