DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
the place where data is stored in a database
|
|
|
the report you can run using a databse
|
|
|
another word for spreadsheet
|
|
|
another word for database
|
Detailed explanation-1: -In relational databases, and flat file databases, a table is a set of data elements (values) using a model of vertical columns (identifiable by 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.
Detailed explanation-2: -Database storage structure All the information in a database is organized and structured in database tables. These tables are stored on the hard disk of the database server. The database tables are usually divided into columns and rows, just like a regular graphic table.
Detailed explanation-3: -A relational database like Access usually has several related tables. In a well-designed database, each table stores data about a particular subject, such as employees or products. A table has records (rows) and fields (columns).
Detailed explanation-4: -A database table is also called a relation. Tables have rows and columns: A row is a database record, called a tuple; a column is called an attribute. A single cell (the intersection of a row and a column) in a database is called a value.
Detailed explanation-5: -Data elements within the database are stored in the form of simple tables. Tables are related if they contain common fields. 4. DBMS packages based on the relational model can link data elements from various tables to provide information to users.