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

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...

۱۵۔ میری ماں نہیں رہی

دریوزہ گری

پابندِ سلاسلِ قسمت ،یہ خاک زاد

فگار سینے کے بل رینگتا ہوا

سڑکوں پراپنی بے پائی گھسیٹتا ہوا

کٹے ہوئے دست و بازو لہراتا ہوا

صدائے سوال بلند کرتا ہے

جس کی غلاظت بھری حریص سوچوں کی تلوار نے

خودی کا سر قلم کر دیا ہے

سڑک کے دوسری طرف سیاہ برقعے میں لپٹی دو خشمگیں نگاہیں

ہر گزرنے والے کو سوالیہ انداز میں دیکھتی ہیں

غربت...

سيميائية اللّون واستراتيجية الدّلالة في شعر حازم رشك: دراسة نفسية تحليلية

يهدف البحث لبيان تأثير الألوان النفسية ومفعولها الفني في بناء القصيدة المعاصرة عند حازم رشك، بما لها من وسْع تعبيري لا يتوافر في اللغة الإنسانية العادية، تلك التي تبدو قاصرة عن ترجمة الأغوار النفسية، واستكناه عنصر الطبيعة في تناسق ألوانها اللامتناهي الذي يُعدّ مادة خصبة للفيض الفني عند الشعراء المبدعين. ولتثبيت الحقائق سلكت الدراسة منهجاً إحصائياً تحليلياً وروائز علمية كشفت عن ميْل بعضهم في جملة من المواقف الإنسانية إلى تفضيل ألوان معيّنة، كما أكدت الدّراسة أن طغيان استعمال ألوان معيّنة ما هو في الحقيقة إلا ظاهرة فنية عاطفيّة أحسنَ التميمي توظيفها.

Developing Students Writing Skills Through Feedback

Learning through feedback is currently an important topic for researchers and teachers. Feedback is an important part of teaching, which is used in our daily classroom practices in different forms i.e. written, verbal and non-verbal. In the classroom, it takes place between the teacher and the students or between or among the students. Feedback is considered to be an important learning tool if it is given and acted upon effectively. This study is an effort to find the answer to the question of how a teacher can provide feedback to the English as a Second Language (ESL) primary school students in a way, which will help them to develop their writing skills. To answer the question, an action research was conducted in a classroom setting. An attempt has been made to make the feedback constructive by describing the students' actual performance, giving encouragement and specific suggestions for further improvement. Feedback was provided in writing as well as verbally. To examine the impact of the feedback the study followed a process writing approach, in which the focus of the feedback was on: content, syntax, grammar and mechanics, organization and vocabulary. The writing process involved two cycles. Each cycle had one topic comprising of three drafts. The classroom teacher's services were utilized in planning, teaching, classroom management as well as in providing feedback to half of the class. The data has been gathered through interviews, conferencing, research memos and from students' drafts. The effects of the feedback in developing students' writing skills have been seen by analyzing the drafts of eight students and by exploring their views about the feedback. The findings show that the feedback helped the students in bringing about specific changes in different areas of their writing including content, syntax, conventions, organization and vocabulary. The students who incorporated the feedback in their writing made visible improvement while those who did not incorporate it thoroughly in their writing made less improvement. The feedback was viewed as encouraging, helpful, motivating for learning, enjoyable and thought provoking, in terms of highlighting the potential for improvement in the need areas.