QUESTION 1What is true with respect to a row’s primary key? Select ALL answers that apply.A.The primary key should contain a value that should never change; the value should be immutable.B.The primary key must not contain the value null.C.The primary key uniquely identifies each row in a table.D.The primary key of one table is used only to create a relationship to a different table’s primary key.2 points QUESTION 2In the drawing shown below, what kind of relationship exists between the Customers table and the Titles table? Select the best answer from the following. A.One-To-One relationship.B.One-To-Many relationship.C.Many-To-Many relationship using the StreamingHistory table as a composite entity.D.There is no relationship between the Customers and the Titles tables.2 points QUESTION 3In the drawing shown below, what kind of relationship exists between the Empoyee table and the EmployeePayHistory table? Select the best answer from the following. A.One-To-One relationship.B.One-To-Many relationship.C.Many-To-Many relationship.D.From the diagram given you cannot tell if there are any relationships between these two tables.2 points QUESTION 4Referencing the table below, what can you say about the following T-SQL Delete statement? Select the best answer from the following. A.This statement will not run because it is incomplete.B.This statement will not run because it is invalid due to invalid syntax.C.This statement will delete all the rows from the Movies table.D.This statement will delete the Movies table—remove the table from the database.2 points QUESTION 5In cloud architecture, which of the following is an example of SaaS? Select the best answer from the following.A.A database is hosted in a data center and is provided to the customer as a service. You have no control over the infrastructure, server, operating system, etc. You control only database itself.B.A database is installed on a virtual machine that resides in the cloud infrastructure. You have control over the operating system, but not to the physical hardware.C.A database is installed in an on-premise infrastructure. You have complete control over the infrastructure, hardware, operating system, etc.D.A database cannot be provisioned in a Software as a Service environment.2 points QUESTION 6Referencing the table below, what can you say about the following T-SQL Insert statement? Note that the Id column is an identity specification. Select the best answer from the following. A.This insert statement will insert exactly one row into the Movies table.B.This insert statement will fail because the Id column is not included in the list of columns.C.This insert statement will fail because neither the RottenTomatoesScore nor the TotalEarned columns are included in the list of columns.D.This insert statement will fail because the syntax is wrong.2 points QUESTION 7The ‘T’ in T-SQL stands for, what? Select the best answer from the following. A.TransactB.TypedC.Trans NotationalD.Translated2 points QUESTION 8What is an “attribute”? Select the best answer from the following.A.An attribute is the same, or synonymous with, a column in a table.B.An attribute, for our purposes, is the same as a table in the database.C.There are no attributes in a relational database. Attributes are only part of NoSQL databases.D.An attribute provides the meta-data about the entire database.2 points QUESTION 9Which of the following is NOT a tool used in conducting needs assessments? Select the best answer from the following.A.Agile.B.Observation.C.Interviews.D.Questionnaires.2 points QUESTION 10Referencing the table below, what can you say about the following T-SQL Update statement? Select the best answer from the following. A.This statement will not run because it is incomplete.B.This statement will not run because it is invalid due to invalid syntax.C.This statement will update the first row that it finds in the table setting the Year column = 2020.D.This statement will update all the rows in the table setting the Year column = 2020.2 points QUESTION 11When thinking about the normalization process/normalizing our database, what do we know about multivalued attributes? Select the best answer from the following.A.Normalization requires that we use multivalued data in a relational database.B.Normalization doesn’t address this issue. Single- versus multi-valued attributes is simply a design choice and is an issue that is left up to the personal choices of the database designer.C.This is not an issue for relational databases. Discussion of multivalued attributes only occurs in NoSQL databases.D.In the design of a relational database there should never be multivalued attributes. 2 points QUESTION 12What is “Referential Integrity”? Select the best answer from the following.A.Referential integrity is a process followed by database designers to ensure their database designs are correct.B.Referential integrity is not part of the relational database design.C.Referential integrity is achieved when related tables are grouped together within a schema.D.Referential integrity is a constraint enforced by the DBMS that ensures consistency of the cross-references between and among tables.2 points QUESTION 13Insert the correct T-SQL clauses for a basic select command that returns all rows and all columns from a table called Employees filtered by the State column and sorted by the EmployeeLastName column. * Employees State = ‘OH’ EmployeeLastName2 points QUESTION 14In a relational database how is data integrity achieved? Select the best answer from the following.A.Data integrity is achieved through online transaction processing or OLTP.B.Data integrity is achieved through three-valued predicate logic supporting the Null marker.C.Data integrity is achieved and enforced through the software built to interact with a database.D.Data integrity is achieved through rules called constraints.2 points QUESTION 15Which of the following is work that is done as part of systems analysis? Select ALL answers that apply.A.Systems analysis helps to ensure the database design reflects the needs of the organization.B.Systems analysis helps in understanding the environment in which the database will be deployed.C.Systems analysis helps to ensure everyone in the organization understands the technical design of the database.D.Systems analysis helps in knowing how the end product should work.2 points QUESTION 16When joining tables in a Select statement there must exist a common column in both tables and it is a technical requirement that this column have the same name in each table. This statement is . . . Select the best answer from the following. A.TrueB.FalseC.True, but only for SQL Server.D.True, but only for NoSQL database.2 points QUESTION 17The Select statement belong to which category of SQL statements? Select the best answer from the following.A.Data Definition Language (DDL).B.Data Manipulation Language (DML).C.Data Control Language (DCL).D.Set Theory2 points QUESTION 18What is true of foreign keys. Select the best answer from the following.A.A foreign is created by giving it the same name as the column that it matches in the primary (parent) table. The DBMS automatically links the tables based on the column names.B.A foreign key is a column or columns whose value is the same as the primary key of another table in the database. In some cases, a foreign key can be created within the same table as primary key, but this is rare.C.A foreign key is a hidden column in a table that contains multiple pieces of information so that two or more tables can be related together.D.Foreign keys are not used in relational database design.2 points QUESTION 19What is an “ERD”? Select the best answer from the following.A.An ERD is an Entity-Relationship diagram.B.An ERD means that there is an “Error in the Relational Design.”C.An ERD is an Elemental Redesign Document.D.ERD is the service in AWS where a database is created.2 points QUESTION 20What is a relational database? Select the best answer from the following.A.An organized collection of structured data, and information about relationships.B.Any organized list that contains data is “technically” a relational database.C.A collection of information stored in a central repository that can be queried.D.Any system that can process online transactions (OLTP).2 points QUESTION 21The term Relational in the context of a relational databases means what? Select the best answer from the following.A.The term Relational stems from the fact that relational databases form relationships between tables.B.The term Relational comes from the title of the seminal paper written by E.F. Codd—the father of the relational database.C.The term Relational is related to the mathematic term relationin set theory.D.The term Relational refers to a set of unrelated information.2 points QUESTION 22What is an “entity”? Select the best answer from the following.A.An entity represents one of the columns in an individual table.B.There are no entities in a relational database. Entities are only part of NoSQL databases.C.An entity provides the meta-data about the entire database.D.An entity, for our purposes, is the same as a table in the database.2 points QUESTION 23You know that you have a lot of old data in the Courses table where those courses have not been taught in years and never will be again—meaning that no current Student rows are matched to these old Courses rows. You want to identify which rows in Courses are no longer matched with any Students. Which is the best join to use to accomplish this? Select the best answer from the following.A.The inner join will produce the result set needed.B.You must use a self-join to produce the result set needed.C.You will have to query each table individually and match the results in Excel to answer the question.D.You can use either the left or right join to produce the result set needed.2 points QUESTION 24What is a DBMS? Select the best answer from the following.A.A DBMS is a collection of programs enabling users to access databases, manipulate data, and present data.B.A DBMS serves as an intermediary between applications that use a database and open-source database technologies.C.DBMS is an outdated term used to refer to database technology before the advancement of relational database management systems.D.A DBMS is any program or application that has a relational database as its backend.2 points QUESTION 25What kind of processing is ideally suited for using a Relational Databases? Select the best answer from the following.A.Service Oriented Architecture (SOA)B.Data warehousing.C.Online Transaction Processing (OLTP)D.Stream data processing.2 points QUESTION 26What does a primary key constraint enforce or do? Select the best answer from the following.A.Tables containing multiple primary keys allows for fast searches on the table’s data.B.Primary keys enforces referential integrity.C.Primary keys enforce the uniqueness of rows.D.Primary keys enforce check constraints forcing rows to meet certain criteria before being allowed into the database.2 points QUESTION 27What is a “meaningful” identifier? Select the best answer from the following.A.This generally is a key that contains sensitive information that needs to be protected.B.This generally is a key where the value of the key carries implicit meaning.C.This is a key that will never be changed because the information it contains must never be lost.D.A “meaningful” identifier is always the same as a foreign key in a relationship.2 points QUESTION 28In the drawing shown below, what is the database term for the text ‘HumanResources’ shown in the parenthesis next to each of the table names? Select the best answer from the following. A.HumanResources is an attribute in both of these tables.B.HumanResources is an entity in both of these tables.C.HumanResources is the schema to which each of the two tables belong.D.HumanResources is simply part of the table name itself. For example, the full table name for one of the tables is ‘Employee (HumanResources)’.2 points QUESTION 29Referencing the table below, what can you say about the design of the table? Select ALL answers that apply. A.This table contains all the attributes (columns) that are needed.B.This table is okay as a start but does violate normalization rules—specifically it is not in Third Normal Form (3NF).C.I can’t know without doing good systems analysis work whether this table meets the organization’s needs.D.The design of this table is perfect for the software application that will use it.2 points QUESTION 30Which of the following is true when using an inner join? Select the best answer from the following.A.Only rows from the left-side of the join are returned if there is no match for that row in the table on the right-side of the join.B.All rows from the left-side of the join are returned and then matched against related rows from the table on the right-side of the join.C.All rows from the right-side of the join are returned and then matched against related rows from the table on the left-side of the join.D.Only rows that have related rows on both sides of the join are returned.2 points Click Save and Submit to save and submit. Click Save All Answers to save all answers.

Instructions are attached. They should be everything that is needed. If there any questions please do not hesitate to ask

...............,,, ................................. xxxxxxxxxxxxxxxxxxxxxxx.......