1) List one situation in which it is not recommended to use a DBMS approach to data modeling.

2) 

1. Using your downloaded DBMS (MS SQL Server), create SQL queries that inserts at least three rows in each table.
2. Create SQL queries that update one row in each table.
3. Create SQL queries that retrieve an entire table (any table that you choose).

using Microsoft SQL Server Management Studio 17. 

Answer:

1.

Data Modeling : Data modelling is the first step in the process of database design.  Data models define how data is connected to each other and how they are processed and stored inside the system.Data Models are fundamental entities to introduce abstraction in a DBMS.

There are several different approaches to data modeling, including:

Conceptual Data Modeling - identifies the highest-level relationships between different entities.

Logical Data Modeling - Illustrates the specific entities, attributes and relationships involved in a business function. Serves as the basis for the creation of the physical data model.

Physical Data Modeling - represents an application and database-specific implementation of a logical data model.

Although there are many advantages of using DBMS in data modeling but there are two situations in which they are not recommended:

1. When an extreme access speed is required. In this case, the applications should store the data directly in the RAM (Random Access Memory).

2 .When the data and applications are simple and stable – for example : in the case of an address book;

2.

//Creating Table for Employee and Department
CREATE TABLE Employee(
employeeno INT PRIMARY KEY,
employeename VARCHAR(10),
employeejob VARCHAR(9),
employeemgr INT NULL,
hiredate DATETIME,
employeesal NUMERIC(7,2),
employeecomm NUMERIC(7,2) NULL,
deptartment INT)
begin
//Entering values into newly created table.
insert into Employee values
    (1,'ABCD','admin',7,'04-19-2019',28000,NULL,3)
insert into Employee values
    (2,'XYZ','MANAGER',6,'04-12-2019',58000,430,4)
insert into Employee values
    (3,'PQRS','SALES Executive',2,'04-15-2019',25000,500,5)
end
CREATE TABLE deptartment(
departmentid INT NOT NULL,
departmentname VARCHAR(14),
locality VARCHAR(13))
begin
insert into deptartment values (1,'ACCOUNTING','ABCD2')
insert into deptartment values (2,'RESEARCH','XYZ1')
insert into deptartment values (3,'SALES','PQRST3')
end

//Updating row in a table

begin
UPDATE Employee SET employeesal = 50000 WHERE employeeno = 3;
end
begin
UPDATE department SET locality = 'LMNO5' WHERE departmentid = 1;
end

//Retrieving Entire table

begin

SELECT * FROM Employee;

end

begin

SELCET * FROM department;

end