SQL Terminology Homework (multiple pages) Answer the following question related to material in the textbook or that have been discussed in class lab Just fill in your definition in this Word document and submit to dropbox Be complete and specific in your answers Question8e Your answer What is the name of the physical database (i e in Microsoft Access) component(s) that is typically created from the Entity component of an ERD What is the name of the physical database (i e in MS Microsoft Access) component(s) that is typically created from the Attribute component of an ERD What is the name of the physical database (i e in MS Microsoft Access) component(s) that is typically created from the Identifier component of an ERD What is the name of the physical database (i e in MS Microsoft Access) component(s) that is typically created from the Relationship component of an ERD What does the term row mean in a physical database What does the term column mean in a physical database What does the term SQL stand for What is SQL used for What SQL statement command is used to add a new table to an existing database What SQL statement command is used to add a new row of data in an existing table What SQL statement command is used to update an existing row of data in a table What SQL statement command is used to delete a row of data from a table In your own words describe the meaning of NULL NOT NULL when used with a CREATE TABLE command give an example of when you might use NULL, give an example of when you might use NOT NULL Give an example of defining a Constraint within a CREATE TABLE command show some sample SQL and describe its meaning What SQL statement command is used to retrieve existing data from a table What is the term WHERE used for in SQL in your own words What is the term ORDER BY used for in SQL in your own words Name 4 different data types allowed in SQL as discussed in class or in the book (see Chapter 3 in the textbook) What is the difference between a column defined with data type CHAR(100) vs VARCHAR(100) When is a good time to use a VARCHAR instead of a CHAR for text data Name 3 field column data types that can be used to hold varying sizes of Integer data Name a field column data type that can be used to hold decimal data What are some examples of situations when it makes more sense to define a field with a numeric data type than with a character data type be specific and give examples In your own words describe the largest positive numeric value and smallest negative numeric value that this data type will hold (see Chapter 3 in the textbook) NUMBER(7,3) same as DECIMAL(7,3)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 25, 2024

SQL Terminology Homework (multiple pages) Answer the following question related to material in the textbook or that have been discussed in class/lab. Just fill in

SQL Terminology Homework (multiple pages)

Answer the following question related to material in the textbook or that have been discussed in class/lab. Just fill in your definition in this Word document and submit to dropbox. Be complete and specific in your answers.

Question8e	Your answer
What is the name of the physical database (i.e. in Microsoft Access) component(s) that is typically created from the Entity component of an ERD ?
What is the name of the physical database (i.e. in MS Microsoft Access) component(s) that is typically created from the Attribute component of an ERD ?
What is the name of the physical database (i.e. in MS Microsoft Access) component(s) that is typically created from the Identifier component of an ERD ?
What is the name of the physical database (i.e. in MS Microsoft Access) component(s) that is typically created from the Relationship component of an ERD ?
What does the term row mean in a physical database ? What does the term column mean in a physical database ?
What does the term SQL stand for ?
What is SQL used for ?
What SQL statement/command is used to add a new table to an existing database ?
What SQL statement/command is used to add a new row of data in an existing table ?
What SQL statement/command is used to update an existing row of data in a table ?
What SQL statement/command is used to delete a row of data from a table ?
In your own words describe the meaning of NULL/NOT NULL when used with a CREATE TABLE command; give an example of when you might use NULL, give an example of when you might use NOT NULL
Give an example of defining a Constraint within a CREATE TABLE command; show some sample SQL and describe its meaning
What SQL statement/command is used to retrieve existing data from a table ?
What is the term WHERE used for in SQL in your own words ?
What is the term ORDER BY used for in SQL in your own words ?
Name 4 different data types allowed in SQL as discussed in class or in the book ? (see Chapter 3 in the textbook)
What is the difference between a column defined with data type CHAR(100) vs. VARCHAR(100) ? When is a good time to use a VARCHAR instead of a CHAR for text data ?
Name 3 field/column data types that can be used to hold varying sizes of Integer data ?
Name a field/column data type that can be used to hold decimal data ?
What are some examples of situations when it makes more sense to define a field with a numeric data type than with a character data type ? be specific and give examples
In your own words describe the largest positive numeric value and smallest negative numeric value that this data type will hold (see Chapter 3 in the textbook) NUMBER(7,3) [same as DECIMAL(7,3)]