• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 1 fuera de 4 páginas
Examen

Chapter 1: An introduction to relational databases and SQL with complete solutions

Document preview thumbnail
Vista previa 1 fuera de 4 páginas

What are the three hardware components of a client/server system? (Chapter 1 Objective) clients server network Describe the way a client accesses the database on a server using these terms: application software, data access API, database management system, SQL query, and query results. (Chapter 1 Objective) Application software uses the data that's stored on a server and it does that using a data access API. The client communicates with a server via SQL queries that are passed through DBMS through the API. When the client sends a query the DBMS interprets the query and sends it back. Describe the way a relational database is organized using these terms: tables, columns, rows, cells, primary keys, and foreign keys.(Chapter 1 Objective) A relational database consist of tables. Tables have rows and columns. A column is an attribute of an entity and a row is a set of values for a single instance. Cells are the intersections of rows and columns that store a single value. A primary key is a single column that identifies each row in a table. Identify the three types of relationships that can exist between two tables. (Chapter 1 Objective) One-to-many relationship One-to-one relationship Many-to-many relationship Describe the way the columns in a table are defined using these terms: data type, null value, and default value. (Chapter 1 Objective) The data type that's assigned to a column determines the type of information that can be stored in the column. The column information determines whether or not it can contain null values. A column can be defined with a default value which is used when another value isn't provided. Describe the difference between DML statements and DDL statements. (Chapter 1 Objective) DML stands for data manipulation language and DDL stands for data definition language Describe the difference between an action query and a SELECT query. (Chapter 1 Objective) A SELECT query retrieves data and an action query alters it. List three coding techniques that can make your SQL code easier to read and maintain. (Chapter 1 Objective) Capitalize all keywords. Use lowercase for the other code. Separate the words in names with underscores. Start each clause on a new line. Break long clauses into multiple lines. Indent continued lines. Use comments only for code that is hard to understand. Make sure that the comments are correct and up-to-date. Explain how views and stored procedures differ from SQL statements that are issued from an application program. (Chapter 1 Objective) Describe the use of a database driver. (Chapter 1 Objective) What are clients? Clients are the PCs, Macintoshes, or workstations of the system What is a server? A server is a computer that stores the files and databases of the system and provides services to the clients. When it stores databases, it's often referred to as a database server. What is a network? consists of the cabling, communication lines, and other components that connect the clients and the servers of the system How does a web application work? Web browser on a client sends a request to a web server. Web server processes the request. Web server passes any data requests to the database server. Database server returns results to web server. Web server returns a response to the browser. sequence Result table (result set) the result of a select statement is a result table, or result set calculated values are calculated from columns in table query a select statement is commonly referred to as a query join when a SELECT statement retrieves data from two tables and is joined into a single result set inner join rows from two tables are included in the result only if their related columns match outer joins lets you include all rows from a table even if the other table doesn't have a matching row action query queries that add, change or delete data (INSERT, UPDATE, DELETE) view


Información del documento

Subido en
17 de febrero de 2024
Número de páginas
4
Escrito en
2023/2024
Tipo
Examen
Contiene
Preguntas y respuestas
$15.99

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
GUARANTEEDSUCCESS
4.3
(254)
Vendido
697
Seguidores
314
Artículos
24783
Última venta
1 semana hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes

Ups! No podemos cargar tu documento ahora. Inténtalo de nuevo o contacta con soporte.