On database normalization using user interface normal form
Database is important to ensure the data can be store, update and retrieve back. The famous data modelling using the Entity Relationship Model already introduced more than thirty years. However, designing a good database is still a big issue especially in designing optimum database because it is ver...
Saved in:
| Main Authors: | , , , |
|---|---|
| Format: | Conference or Workshop Item |
| Published: |
2010
|
| Subjects: | |
| Online Access: | http://eprints.uthm.edu.my/3599/ |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Summary: | Database is important to ensure the data can be store, update and retrieve back. The famous data modelling using the Entity Relationship Model already introduced more than thirty years. However, designing a good database is still a big issue especially in designing optimum database because it is very hard to do consistency checking between system design and database design to fulfil user needs. In this paper, we propose an alternative method for designing optimum database system based on object oriented methodology. The schema table is extracted from class diagram and then the schema will be compared with the user interface to normalize the structure. Data sanitization is introduced to remove the unused attributes to provide final schema table. |
|---|