Introduction to Databases Flashcards
What is data?
A collection of facts in a raw or unorganized form.
What is information?
Data that is organized in a way that gives it meaning, relevance, and usability.
What is a database?
A repository of data that allows users to retrieve, update, and analyze information. Databases are organized as groups of linked tables.
What is a relational database?
A relational database allows the tables to be linked to each other using a mutual element. For example, Customer ID might belong to both the CustomerID field and the Orders field.
What is a hierarchical database?
A hierarchical database organizes data using the parent-child format (one to many), where the parent can have many children, but children are only allowed to have one parent. For example, a customer might have multiple orders that hold multiple products.
What SQL statement keyword reads (queries) a table?
SELECT statement
What can be inserted, updated, and deleted from a table?
Data
What is an Entity Relationship Diagram?
It’s a map of different tables in a database to show which data categories are present in multiple tables. For example, AlbumId might show up in Album and the Track Table.
What is a view?
A view is like a saved query. When you use it, the database runs the query and shows you the results as a table. It can combine data from multiple sources.
What is a stored procedures
It is a set of SQL statements that you can save and reuse.
What is a user-defined function?
A function that is created by the user to perform specific actions that can be called within SQL queries. You would create a function and then reuse that function to return an answer or a table.
What is T-SQL?
It’s Microsoft’s version of SQL language and follows ANSI standards.
What is SQL Server Management Studio?
It is a tool to connect to SQL servers.
Are you able to connect to more than one SQL server from your SQL Server Management Studio?
Yes!
