Logical Database Design

  • Dana Rasul Hamad Department of computer science, Faculty of Science, Soran University, Kurdistan Region


The design, development and implementation of every database are mainly to serve as an information hub for organisations. The database is a key factor to the success of most organisations. The process of designing a database usually takes numerous steps which involves the use of various tools and techniques during the design so as to ensure that the database provides data that is of good quality and correct at the same time. This write up is going to contain a reflection on an assignment submitted for the design of a database for a company called courtesy active mobile phones. Various database design tools such as class diagrams use case models and Entity relational diagram were used for the design of the database.


Batini, C., Ceri, S., & Navathe, S. (1989). Entity Relationship Approach. Elsevier Science Publishers BV (North Holland).
Bruegge, B., & Dutoit, A. H. (2004). Object-Oriented Software Engineering Using UML, Patterns and Java-(Required). Prentice Hall.
Ceri, S., navathe, S. and wiederhold, G. (1983). Distribution design of logical database schemas. . IEEE transactions on software engineering, 9 (4), 487-504.
Colpoys, L., Purchase, H. CMcGill, M., Carrington, D., & Britton, C. (2001, December). UML class diagram syntax: an empirical study of comprehension. In Proceedings of the 2001 Asia-Pacific symposium on Information visualisation- 9 (113-120).
Elizabeth fong, N. and National Bureau of Standards (DOC), Washington,DC.Inst.for Computer Sciences and Technology (1985). Guide on logical database design. [online]. at: http://shu.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwY2AwNtIz0EUrE1ITLZMSLZKSEg3NkowM04DtjGRjE5NUgzRzy2SDFNNklGMMeBDllpsQA1NqniiDjJtriLOHLmgOI74AcgxDvKuLEaj6MzEUY-BNBC0HzysBbxtLAQBAOCGp .
Garmany, John, walker, Jeff and clark, Terry (2004). Logical database design principles. Boca Raton, Fla; London, Auerbach. at:
Gavin Powell 2006 beginning Database design
Hendrickson, Scott, jett, Bryan and van der hoek, André (2006). Layered class diagrams: Supporting the design process, Berlin, Heidelberg
Hoxmeier, j, A. (1997) A Framework for Assessing Database Quality [online] last accessed 7th May 2014 at http://osm7.cs.byu.edu/ER97/workshop4/jh.html
PETER Rob, CARLOS Coronel and KEELEY Crockett 2008 Database systems (Design Implementation and management
Rebecca M. Riordan 2005 Designing Effective Database Systems
Sengupta, S., & Bhattacharya, S. (2006). Formalization of UML use case diagram-a Z notation based approach. IEEE International Conference on Computing & Informatics (pp. 1-6).
Siau, Keng and lee, Lihyunn (2004). Are use case and class diagrams complementary in requirements analysis? an experimental study on use case and class diagrams in UML (4), 229-237.
Teorey, Toby J., lightstone, Sam and nadeau, Tom (2006). Database modeling and design: Logical design. [online]. Amsterdam; London, Morgan Kaufmann. at: http://shu.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwY2AwNtIz0EUrE1ITLZMSLZKSEg3NkowM04DtjGRjE5NUgzRzy2SDFNNklGMMeBDll5sQA1NqniiDjJtriLOHbnFGaTx0WCM-CVjTmwGra0tDMQbeRNBy8LwS8LaxFAA6riFv.
Connolly ,Thomas, and Begg ,carolyn (2010) Database systems 5th ed.pearson
Veda C. Storey and richard Y. Wang (1996) Modelling Quality requirements in Conceptual database [online] last accessed 5 May 2014 at: http://web.mit.edu/tdqm/www/papers/94/94-02.html
Vitalie, C. (2012). Contributions to logical database design, . Informatica economica journal, 16 (1), 14-27.
Vidgen, R. (2003). Requirements analysis and UML - use cases and class diagrams, Computing & control engineering journal, 14 (1), 12-17.
How to Cite
Hamad, D. R. (2016). Logical Database Design. INTERNATIONAL JOURNAL OF COMPUTERS & TECHNOLOGY, 15(12), 7329-7332. https://doi.org/10.24297/ijct.v15i12.4344