This chapter is from the book
This chapter is from the book
This chapter is from the book
Q&A
Q. If I learn SQL, can I use any of the implementations that use SQL?
A. Yes, you can communicate with a database whose implementation is compliant with ANSI SQL. If an implementation is not completely compliant, you likely will pick it up quickly with some adjustments.
Q. In a client/server environment, is the personal computer the client or the server?
A. The personal computer is the client in a client/server environment, although a server can also serve as a client.
Q. In the context of a database, how do information and usable data differ?
A. Information and data are conceptually the same. However, when you are creating a database, it is important to gather all required information and work to form that information into usable data. Usable data comes from reliable sources and is accurate, consistent, clean, and up-to-date. Usable data is critical for business operations and when making critical decisions. Data that is derived from inaccurate sources or that has not properly been entered or evolved with the database is not usable.
Q. Can SQL be used to integrate databases among multiple environments, platforms, or types of databases?
A. When working with a relational database, SQL is the primary language and tool for working with data, including integrating data among multiple sources. SQL is also necessary when migrating data between sources. Medium to large organizations commonly have many different sources of data, only some of which are SQL based. SQL is an important component for pulling everything together.