Question: Questions: 1- With what other computer system software does a DBMS interact? 2-Discuss the entity integrity and referential integrity constraints. Why is each considered important?
Questions:
1- With what other computer system software does a DBMS interact? 2-Discuss the entity integrity and referential integrity constraints. Why is each considered important? 3- What is the difference between a key and a superkey? 4- What is collation? 5- List the various cases where use of a NULL value would be appropriate. 6- What is subquery? 7- What is a stored procedure? 8- Discuss the main categories of data models. What are the basic differencesamong the relational model, the object model, and the XML model? 9- What is CLAUSE? 10- Write a query to the database (use Data_2021_01_28.txt data for Platon platform): Find all products in the lights subcategory. If you think you can't do the assignment, write why. 11 -Design a notepad database (you register: name, surname, academic title, telephones, emails addresses 12 -Describe how SQL queries work: SELECT AVG(TotalDue) as AVG_TotalDue FROM [Sales].[SalesOrderHeader]
MyDatabase Querry for reference on number 10-12
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
