Relational databases - Study guides, Class notes & Summaries

Which requirement within large, complex databases ensures users have limited access to the database? Recovery Performance Authorization Confidentiality Authorization Which design type specifies database requirements without regard to a specific database system? Physical design Conceptual design Logical design Abstract design Conceptual design 3. What characterizes the rules of relational databases? -They are logical constraints that ensure the data is valid. -They are...

Sophia Introduction to Relational Databases Milestone 2, Answered

Introduction to Relational Databases Milestone 1 Retake Questions and Answers (Score 33/36) Latest. 33/36  that's 92% RETAKE  33 questions were answered correctly. 3 questions were answered incorrectly. In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. Identify the correctly constructed ALTER TABLE statement to add a UNIQUE const...

WGU CS1011 Sophia Introduction to Relational Databases Milestone 2 Retake Questions and Answers Score 20/25. 20/25  that's 80% RETAKE  20 questions were answered correctly. 4 questions were answered incorrectly. 1 question was skipped. These were marked incorrect. In each milestone, you may want or need to use the database and query tool to answer some of the questions. We suggest you open the tool in another browser tab while you are working on this assessment. Which of the fol...

Which of the following queries will use a subquery to find the rows in the invoice table in the country USA that have the invoice total larger than the average of invoices of those in the country Canada?
a.)
SELECT * FROM invoice
WHERE total >
(SELECT AVG(total) FROM invoice
WHERE billing_country = 'Canada') AND billing_country = 'USA';
b.)
SELECT * FROM invoice
WHERE total >
(SELECT AVG(total) FROM invoice
WHERE billing_country = 'USA') AND billing_...

Sophia Introduction to Relational Databases Milestone_3. (Score 95%)

Sophia Introduction to Relational Databases Milestone 2, Answered

Schema The definition of how data in a database will be organized. - Create - Read - Update - Delete The basis of interacting with databases can be defined using the CRUD acronym. What does CRUD stand for? Brainpower 0:02 / 0:15 DATE: YYYY-MM-DD DATETIME: YYYY-MM-DD HH:MM:SS What is the DATE datatype syntax? What is the DATETIME datatype syntax? It will have 3 numbers before the decimal and 2 after. What does DECIMAL(3,2) indicate? Stored Procedures ...

All invoices from USA will require a fee paid to an external organization for 10% of the total. Which of the following statements would query the sum of the total of the invoices in the country USA and calculate 10% of it?
a.)
SELECT AVG(total*.10) AS calculated_fee FROM invoice
WHERE billing_country = 'USA';
b.)
SELECT total(SUM)*.10 AS calculated_fee FROM invoice
WHERE billing_country = 'USA';
c.)
SELECT SUM(total)*.10 AS calculated_fee FROM invoice
WHERE bill...

Sophia Introduction to Relational Databases Milestone 1, Answered