Search or add a thesis

Advanced Search (Beta)
Home > Improving Conceptual Modelling in Database Design

Improving Conceptual Modelling in Database Design

Thesis Info

Access Option

External Link

Author

Hussain, Tauqeer

Program

PhD

Institute

Lahore University of Management Sciences

City

Lahore

Province

Punjab

Country

Pakistan

Thesis Completing Year

2006

Thesis Completion Status

Completed

Subject

Applied Sciences

Language

English

Link

http://prr.hec.gov.pk/jspui/handle/123456789/120

Added

2021-02-17 19:49:13

Modified

2024-03-24 20:25:49

ARI ID

1676726434992

Asian Research Index Whatsapp Chanel
Asian Research Index Whatsapp Chanel

Join our Whatsapp Channel to get regular updates.

Similar


Conceptual Modeling is one of the most important stages of the database (DB) design methodology. A number of approaches for conceptual modeling have been devised in the literature amongst which the Entity-Relationship (ER) modeling technique is extensively used. Since the quality of a conceptual model impacts the quality of the end product, our research focuses on how the quality of an ER model can be improved. We have identified modeling problems in the existing ER modeling technique and have suggested an approach which solves these problems. The result is an improved ER model which closely represents the real-world problem thereby improving the semantic representation. Our proposed approach incorporates real-world constraints that can be described in the form of functional dependencies. This approach applies schema transformations iteratively for which a new set of rules has also been defined. New constructs namely single-valued relationship attribute and multi-valued relationship attribute have also been proposed for improving semantics of the relationship types in an ER model. The impact of the proposed approach on later stages of the database design methodology has also been studied which shows that the resulting relational database satisfies higher normal forms as compared to the existing technique. Quantitative aspect of measuring improvement in the quality of a conceptual model is also an integral part of the research. For this purpose, we have proposed new metrics called completeness index, normalization index, and overall quality index. Completeness index is further refined by applying fuzzy logic and thus a fuzzy completeness index is proposed. We have also defined quantitative metrics for the structural complexity of an ER model in terms of correctness and modifiability. These metrics help us compare the quality of two ER models quantitatively and objectively. We have shown with several examples the efficacy of our approach and proposed metrics. The ultimate result is a better database design and improved database designers’ productivity.
Loading...
Loading...

Similar Books

Loading...

Similar Chapters

Loading...

Similar News

Loading...

Similar Articles

Loading...

Similar Article Headings

Loading...

عبدالحلیم شررؔ لکھنوی

مولانا شررؒ
عین اس وقت جب ہم اردو رسالوں کی تاریخ پر ایک سرسری نظر ڈال رہے ہیں، اردو کا وہ سب سے پرانا رسالہ اور اس کا وہ اڈیٹر یاد آتا ہے جس نے سال کے آخری مہینہ کی آخری تاریخوں میں ہماری دنیا کو الوداع کہا، یعنی مولانا عبدالحلیمؔ شرر صاحب لکھنوی، اڈیٹر دل گداز، مولانا ہمارے انشاء پردازوں میں سب سے پرانے انشاء پرداز تھے، اکہتر (۷۱) برس کی عمر میں بعارضۂ فالج وفات پائی، مرحوم نے اپنی عزت اور شہرت تنہا خود اپنے قلم سے حاصل کی تھی، وہ اپنی شہرت کے لئے کسی نامور ہستی سے انتساب کے ممنون نہ تھے، انہوں نے اپنے تمام معاصرین میں سب سے زیادہ اپنی زبان کی خدمت کی فرصت پائی، ہمارے خیال میں ۱۸۸۲؁ء سے انہوں نے اپنے کام کا آغاز کیا اور جو اخیر زمانۂ وفات دسمبر ۱۹۲۶؁ء تک قائم رہا، بیچ بیچ میں کبھی کبھی حیدرآباد کے قیام کی مصروفیتیں پیش آجاتی تھیں، تاہم ان کا تسلسل کبھی ٹوٹنے نہیں پایا، ۴۶ برس کا عہد خدمت ان کے کسی معاصر کو میسر نہیں آیا، پھر ان کی ادبی اور علمی خدمات کی گوناگونی اور کثرت بھی ان کا خاص امتیاز ہے اور یہ کہنا بھی سچ ہے کہ انہیں کی تصنیفات نے اردو میں سینکڑوں انشاء پرداز پیدا کئے اور ملک میں تاریخ کا مذاق پیدا کیا اور سنجیدہ تصنیفات کے لئے حسن قبول کا راستہ صاف کیا۔
خاکسار کو مولانا کا پہلا شرف نیاز ۱۹۰۴؁ء میں حاصل ہوا اور یاد آتا ہے کہ وہ اس وقت حیدرآباد سے واپس آئے تھے اور اتحاد اور پردۂ عصمت نکالنا شروع کیا تھا، وہ عربی زبان کے مستند عالم تھے، بچپن میں وہ اپنے نانا کے ساتھ واجد علی شاہ کے مٹیابرج میں رہے تھے اور اس طرح جب ہوش سنبھالا، تو اپنے کو سخنورانِ اردو...

منتخب جامعات میں ایم۔اے۔ اسلامیات کا نصاب برائے قرآنی علوم: ایک تقابل

Qur’anic Studies is one of the most important aspects of Islamic sciences. It is one of the primary sources of Islamic jurisprudence. This article aims at a comparative study in terms of effectiveness of the Syllabus and mode of Quranic studies at different universities i.e University of Karachi , Allama Iqbal Open University,The University of Punjab, International Islamic University Islamabad and Madina University KSA. The approach covers the methodology employed and problems involved in the imparting of Qur’anic knowledge in connection with Classical mode of Islamic education. The outcome would not only address, in a valid way, the problems of the current system, but will also benefit the scholars and young researchers striving and serving this noble knowledge at post graduate level

Factors Affecting the Performance of Women Entrepreneurship in Kpk: An Empirical Analysis

The study aims to explore the factors that affect women entrepreneurs of Pakistan and to measure the relationship and effect of women entrepreneurial factors on women entrepreneur business performance in Pakistan. The study was descriptive and co-relational in nature. The universe of the study was registered women entrepreneurs of Women Chamber of Commerce & Industry Peshawar, Women Business Development Center Peshawar and non-registered entrepreneurs working at diverse cities of KP, Pakistan. Data collection instrument was questionnaire (5-point Scale). Total 540 questionnaires were distributed among registered and unregistered women entrepreneurs of KP, Pakistan.After data collection from respondents, data was analyzed by using SPSS, AMOS and Liseral software’s. Researcher analyzed the data via descriptive statistics; factor analysis, structure equation model and multiple linear regression model. Findings of the study reveals that there exists significant positive relationship amid women entrepreneurial factors i.e. social factors, economic factors, individual factors, political factors and entrepreneur performance. Factor analysis reveals the exceptionality of the constructs and the questionnaire was found valid for data collection. The collected data was tabulated and found normal, with no multicollinearity, heteroskedasticity and auto-correlation in it. Social factor, economic factor, individual factor, political factor was found a significant constructive predictors of women entrepreneurs performance. There exists an insignificant difference between the responses of women entrepreneur performance about the registered and unregistered women entrepreneurs of KPK, Pakistan. Study recommended that government should focus on the creation and promotion of women entrepreneurship culture b) removal of socio-cultural obstacles prevailing in the society, c) nurturing entrepreneurial culture and environment, d) provision for the women entrepreneurial education opportunities, e) developing friendly and supportive environment infrastructure for women entrepreneurs, and f) forming women entrepreneurs associates. Implication of the study is for the development and promotion of women entrepreneurial culture in Pakistan. Women entrepreneurs become more aware of the importance of social, economic, individual and political factors and its influence on women entrepreneurs performance.