Please use this identifier to cite or link to this item: http://hdl.handle.net/10603/25132
Title: Effective techniques for relational database design through entity relationship modeling normalization and restructuring PL SQL code
Researcher: Vimala, S
Guide(s): Khanna Nehemiah, H
Keywords: Database design
Entity relationship model
Information and communication engineering
PL SQL code
Relational database
Upload Date: 17-Sep-2014
University: Anna University
Completed Date: 01/11/2013
Abstract: Database design is a challenging and complex task due to its importance in the overall performance of the database system Recently various techniques have been under use across different stages of database application modeling design and implementation and they have been under continuous study and improvements by various researchers However the existing techniques are not providing effective guidelines for optimal database design Hence this research work proposes new improvements to the existing design techniques in three specific phases namely logical data modeling logical database design and programming in the database environment Data modeling is necessary to define and analyze data requirements needed to develop real world applications for an organization It involves the conceptual representation which is very powerful in expressing the business requirements The most common and popularly used conceptual data model for relational databases is the Entity Relationship model If the ER model is modeled carefully taking the business rules into consideration and then transformed to relations the resultant relations will be normalized However in most of the scenarios database designers derive relations directly from the requirements without developing ER models which result in poor database design
Pagination: xvii,162p.
URI: http://hdl.handle.net/10603/25132
Appears in Departments:Faculty of Information and Communication Engineering

Files in This Item:
File Description SizeFormat 
01_title.pdfAttached File141.33 kBAdobe PDFView/Open
02_certificates.pdf2.81 MBAdobe PDFView/Open
03_abstract.pdf11.15 kBAdobe PDFView/Open
04_acknowledgement.pdf5.96 kBAdobe PDFView/Open
05_contents.pdf19.05 kBAdobe PDFView/Open
06_chapter1.pdf73.22 kBAdobe PDFView/Open
07_chapter2.pdf104.22 kBAdobe PDFView/Open
08_chapter3.pdf294.67 kBAdobe PDFView/Open
09_chapter4.pdf83.47 kBAdobe PDFView/Open
10_chapter5.pdf72.76 kBAdobe PDFView/Open
11_references.pdf37.25 kBAdobe PDFView/Open
12_appendix.pdf27.78 kBAdobe PDFView/Open
13_publications.pdf5.34 kBAdobe PDFView/Open
14_vitae.pdf5.82 kBAdobe PDFView/Open


Items in Shodhganga are protected by copyright, with all rights reserved, unless otherwise indicated.