Chapter 1 – Review Questions
1.1 What is the purpose of a database? - The purpose of a database is to help people keep track of things.
1.2 What is the most commonly used type of database? - The relational database is the most commonly used type of database. 1.7 Define the terms data and information. Explain how the two terms differ. - Data are facts and figures. Information is defined as knowledge derived from data, or as data presented in a meaningful context. Data is simply recorded in the database, but the data must be manipulated in some way to produce information.
1.12 What is the purpose of the largest databases used by e-commerce companies such as Amazon.com? - The largest databases used by e-commerce companies
…show more content…
- Structured Query Language (SQL) is an internationally recognized standard language used and understood by all commercial database management systems.
1.19 What does DBMS stand for? - DBMS stands for database management system.
1.20 What is the function of the DBMS? - A DBMS creates, processes and administers databases under the control of the DBMS.
1.21 Name three vendors of DBMS products. - Three vendors of DBMS products are Microsoft (Microsoft Access and SQL Server), Oracle Corporation (Oracle Database and MySQL), and IBM (DB2).
1.22 Define the term database. - A database is a self-describing collection of integrated tables, which means that the tables store both data and the relationships between the data.
1.23 Why is a database considered to be self-describing? - A database is considered to be self-describing because it contains a description of itself – such as what tables are in the database, which columns are in each table and what kind of data is stored in each column.
1.24 What is metadata? How does this term pertain to a database? - Metadata is data about data. Metadata in databases allow them to be self-describing.
1.25 What advantage is there in storing metadata in tables? - The advantage of storing metadata in tables is that we can query the metadata to determine the structure of the database – for example, what tables, columns, indexes and data types exist in the database.
1.26 List the components of a
Data objects can model relational data or advanced data types such as graphics, movies, and audio. Smalltalk, C++, Java, and others are objects used in object-oriented data. The object-relational is a combination of relational and object-oriented databases. Traditional and advanced data types can be used to construct database management systems. These systems can connect to a company’s website and update records as needed. Database Approach The main purpose of a database is data storage that can be stored and retrieved when needed. A popular common language called structured query language (SQL) is used to store and retrieve data in relational database. This language enables the systems to run a report or modify data or remove the data from the database. A database management system (DBMS) controls all aspects of a database, this is not limited to the creation, maintenance, and use of database. The DBMS ensures proper applications are able to access the database. An important purpose of a DBMS is to maintain the data definitions (data dictionary) for all the data elements in the database. It also enforces data integrity and security measures. Data Models Data models provide a contextual framework and graphical representation that aid in the definition of data elements. In a relational database, the data model lays the foundation for the database and identifies important entities,
A database is a structural set of related data that is organized in such a way that the information can be easily managed, accessed, and updated. The purpose of a database is to replace paper documents, files, and filing cabinets. The data collected in databases is an efficient way to store, retrieve, and analyze the information.
with information it requires to join the information in the tables together as needed, helps support
Databases are the heart of the company. This is where all crucial company information is stored and can be accessed. Some databases are stored on site others in remote locations or using clouds. The information within a database can be manipulated in any way that the company needs it to be. Databases help to quickly search and retrieve information, it saves from data redundancy.
Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.
A database is an ordered collection of associated information. Database has data that is connected to each other. For example, a database that comprises information about company stock prices must not also contain information about student.
A database is part of a larger system known as an information system, it helps with the collection, storage and retrieval of data. The database structure needs to be defined and its fields labeled properly for it to be an asset to the user.
A database is a collection of data that is organized and is supposed to be organized in such a way that it resembles reality. An example is finding the amount of room on a flight, so you find one with a spare seat available. Databases are supposed to be organized in a way where in the end the users and stake holders that may not have the same knowledge of a database as you, can easily read and
Databases are a combination of populated entities which contain information that is vital in order for organisations to run. Databases are good to use because the entities can be related in this task I will explaining things about databases and its features.
Databases allow us to easily store and retrieve data in a purely digital format. The strength of this is that large amounts of data can be stored and retrieved with minimal effort on the part of the user. Opposed to manually flipping through files, one can quickly pull up the requested data through a computer program. Many systems that were conventionally paper and file based have been converted to a digital format which are now stored in one or more databases.
A database is a “shared collection of logically related data designed to meet the information needs of multiple users in an organization” (Hoffer 709). Databases contain data records or files, such as sales transactions, product catalogs and inventories, and customer profiles. Databases allows multiple users in an organization to easily access, manage, store, and update data when needed.
3. Data complication: Data in occupy in many tables, which are connect to each other through s key value. An RDBMS does not force database designer to impose a coherent table.
Database is a collection of related data stored in several different tables, and linked with each other using foreign keys. A DBMS is a Database Management System, is a piece of software that manages databases and lets you create, edit and delete databases, their tables and their data. Examples of a DBMS include, MySQL, MY SQL Server, Oracle, PostgreSQL, and SQLite.
Table –this is where data is stored for processing and output .The table is defined as a collection of related data consisting of rows and columns. For example, the CUSTOMER or PURCHASES table may comprise of the customer first name, last name address and the product that the customer purchased.
3. effective. security. By divide data into tables, specific tables can be made confidential.it can provide better security for data it can be effective for data and company