header2
1. What is the difference between a DDL and a DML? Describe one example of how
Home » SQL  »  1. What is the difference between a DDL and a DML? Describe one example of how
1. What is the difference between a DDL and a DML? Describe one example of how
1. What is the difference between a DDL and a DML? Describe one example of how you might use each one. 2. Microsoft SQL Server is a popular relational database management system (RDBMS). Referring to the documentation for MS SQL Server, describe, in no more than two to three sentences each, the basic role of the following components of the MS SQL Server system: a) Excel Connection manager b) Cursors c) Security Center Describe each by relating it to one of the generic DBMS components discussed in our textbook shown below(Note that not all of the generic components below are relevant -- you don't have to describe all of these components below): Connection manager Security manager DDL compiler Query processor Storage manager Database utilities 3. Create a MS-SQL Server database on the IST MS SQL Server system. Look at the components of your database using the MS SQL Server Management Studio. Identify one component here and explain which of the generic components shown in Question #2 above this component is. Include a screenshot of your Management Studio Window with the component you are describing. Describe what this component's role is. 4. What is the difference between a relational data model and a NoSQL data model? WHAT TO SUBMIT: Copy these questions (and your answers) into a Word Document or other word processor. Submission file must be either a MS-Word document, an rtf file, or a pdf file.

Leave a Reply

Your email address will not be published.

Click=Order Your Paper Now !