smu semster

ASSIGNMENT
SUMMER DRIVE 2014

DRIVE
PROGRAM

SUBJECT
NAME
BK ID
CREDIT
MARKS

MBADS (SEM 3/SEM 5)
MBAFLEX/ MBA (SEM 3)
PGDISMN (SEM 1)
CODE

& MI0034- DATABASE MANAGEMENT SYSTEMS
B1217
4
60

Note: Answer all questions. Kindly note that answers for 10 marks questions should be approximately of 400 words. Each question is followed by evaluation scheme.

Marks
Total Marks
Q.No Questions
Suppose the employee name, employee id, designation, salary, attendance and address of
1

A

2

A

3

any employee has to be stored in a database. You can store these data in a sequential address book or it can be stored on a hard disk, using a computer and software like
Microsoft Excel. Using this example define a database. List and explain the various procedures carried on in a DBMS with a detailed example of the database. defining a database
1
Listing the 3 procedures
3
10
Explanation
3
One examples for each of them
3

Level 2 cache has got higher latency than Level 1 by 2 times to 10 times in 512 KiB or more. Its value is nearer to kilobyte. This is one of the levels of memory hierarchy. Define memory hierarchy. What are the other levels in memory hierarchy? Explain in one life each for each of them. defining memory hierarchy
1
listing the 6 levels
3
10 explanation 6
EMPLOYEE
EMP_ID
MUL1
MUL2
SMU1
SMU2
SMU3

NAME
Raashi
Taashi
Raksha
Vidhesh
Akhilesh

PROJECT
PR2
PR1
PR3
PR2
PR1

SALARY DEPT_NUM
30000
1
43000
2
25000
3
50000
2
83000
2

A

DEPARTMENT
DEPT_ID
DNAME
PLACE
1
HRM
Bangalore
2
MIS
Bangalore
3
Research
Chennai
4
Finance
Bangalore
Using these tables answer the following question
a. If we want to see all the employees with salary between 40000 and 50000, which query can be used?
b. Select employee name from EMPLOYEE table, whose name starts with R
c. Explain aggregate functions and grouping in detail
a. Query based in BETWEEN operator
2

b. Query based