[go: up one dir, main page]
Scribd
Upload
31 views3 pages

DM Micro Project Report Format

Uploaded by

bariyabhavansing
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
31 views3 pages

DM Micro Project Report Format

Uploaded by

bariyabhavansing
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/ 3

MICRO PROJECT REPORT

GOVERNMENT POLYTECHNIC COLLEGE


HIMATNAGAR
DEPARTMENT OF INFORMATION TECHNOLOGY
Diploma Engineering (SEMESTER: 3rd) year 2024-25

SUBJECT: DATABASE MANAGEMENT SYSTEM


TOPIC:

Submitted by:

Enrollment Number Name


System Name

Description:

System Requirements:

 Registration
 Login
E-R Diagram:

Tables

Normalization:

Normalization is a database design technique that reduces data redundancy and


eliminates undesirable characteristics like Insertion, Update and Deletion anomalies.
It divides larger tables into smaller tables and links them using relationships. The
purpose of Normalization is to eliminate redundant data and ensure data is stored
logically.
The publisher table and the member table has the same fields ‘Name’. So we can
reduce the data redundancy using normalization technique here thereby dividing the
table into two separate table.

Table Creation and data insertion applying normalization:

Fetching Scenarios (Query):

Relational Algebra Queries:

You might also like