• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 1 out of 4 pages
Exam (elaborations)

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

Document preview thumbnail
Preview 1 out of 4 pages

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


Document information

Uploaded on
February 17, 2024
Number of pages
4
Written in
2023/2024
Type
Exam (elaborations)
Contains
Questions & answers
$15.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
GUARANTEEDSUCCESS
4.3
(254)
Sold
697
Followers
314
Items
24783
Last sold
1 week ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions

Whoops! We can’t load your doc right now. Try again or contact support.