In the second query the objective is to ensure that records within the same

In the second query the objective is to ensure that

This preview shows page 3 - 5 out of 5 pages.

creating table I have used the command to create table and alter table. In the second query the objective is to ensure that records within the same table so that it becomes easy to populate the table with the necessary details. Throughout the assessment I was focused on performing different sql commands. I have also learnt the concepts regarding with proper naming in ERD and the way primary and foreign key must be assigned towards the attributes. The database knowledge has improved with the help of this assessment. I can state that with this assessment I have gained knowledge regarding the sql commands, ERD diagrams, tables, primary key and foreign key and their importance. In this query I have used the insert into command for the purpose of a populating the table so that it can store sufficient amount of data. SQL commands are basically divided into different sections that include DDL, DML, DCL, TCL and DQL. While performing the 24 tasks 2
Image of page 3
MIS602 DATA MODELLING & DATABASE DESIGN I have used all the different types of commands in SQL for the purpose of writing queries. The DDL command is used for the purpose of changing the structure of a table like creating a table, altering a table, dropping a table, truncating values and deleting a table. It can be stated that all the DDL commands and auto committed that means they are already saved within a database. The data manipulation language commands are used within the age pool for the purpose of modifying the database. While developing the queries I have used the three commands that comes under DML that is insert, update and delete for performing certain tasks. The transaction control languages can only be used to be there DML commands it that includes the delete update and insert. The commands that I have used for performing the queries includes the commit, roll
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 5 pages?

  • Spring '19
  • Mr. Stein

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture