Scribd
Upload
92 views1 page

Assignment 1

The document discusses an assignment for a Database Management Systems course. It includes the course outcomes, which involve applying database knowledge to real-life applications, query processing, normalization, transactions, and designing a database project. It then lists 5 questions about data modeling concepts, ER diagrams, database languages, keys, and drawing an ER diagram for a hospital management system.

Uploaded by

Mohd Arslaan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
92 views1 page

Assignment 1

The document discusses an assignment for a Database Management Systems course. It includes the course outcomes, which involve applying database knowledge to real-life applications, query processing, normalization, transactions, and designing a database project. It then lists 5 questions about data modeling concepts, ER diagrams, database languages, keys, and drawing an ER diagram for a hospital management system.

Uploaded by

Mohd Arslaan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

IMS Engineering College

NH-09, Adhyatmik Nagar, Near Dasna, Distt. Ghaziabad, U.P.


Tel: (0120) 4940000

Department of Computer Science and Engineering


Database management System (2023-2024)
Assignment 1

Maximum Marks: 20 Submission Date: 22/09/2023


COURSE OUTCOMES

By the end of the course, students will be able to:


CO No. Description Bloom’s Level
C301.1 Apply knowledge of database for real life applications. K3
Apply query processing techniques to automate the real time problems of K3, K4
C301.2
databases.
Identify and solve the redundancy problem in database tables using K2, K3
C301.3
normalization.
Understand the concepts of transactions, their processing so they will familiar K2, K4
C301.4 with broad range of database management issues including data integrity,
security and recovery.
K3, K6
C301.5 Design, develop and implement a small database project using database tools.

ATTEMPT ALL QUESTIONS each question carries equal marks

Q.
Question CO
No.
a. What is data model?
1. C301.1
b. List and explain relationship constraints.
a. Draw ER- diagram for a small marketing company database, assuming your
2. C301.1
own data requirements.
b. Explain Generalization, Specialization, and Aggregation with examples.
a. Explain all database languages. Write the advantages of Database.
3. C301.1
b. Discuss the role of database administrator.
a. Explain Primary key, Super key, Foreign key, Candidate keys with example
4. C301.1
b. Difference between Strong and Weak Entity:
a. Physical and Logical data independence
5. C301.1
b. Draw ER-Diagram for Hospital Management System

You might also like