Premium Essay

Kindly I Need the Answers for the Database : D

In: Computers and Technology

Submitted By Aluratos
Words 1782
Pages 8
Part I http://www.termpaperwarehouse.com/essay-on/Database-Theory-Assignment-1/231867 http://www.docstoc.com/docs/134570160/Problem-Set-ans 1. Given the file structure shown in Figure P1.1, answer Problems a through f.

Figure P1.1 The File Structure for Problems a-f

a) How many records does the file contain, and how many fields are there per record?

b) What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?

c) If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure?

d) What data redundancies do you detect, and how could these redundancies lead to anomalies?

e) Using two relational database tables, PROJECT and MANAGER, eliminate the redundancies discovered in Problem d. Make sure you use the naming conventions discussed in Section 1.3.3 and connect the two tables through the appropriate link. (Hint: Use Figure 1.11 as an example.)

f) Create the relational schema to show how the two database tables in Problem e are linked.

2. Given the file structure shown in Figure P1.7, answer Problems a through g.

Figure P1.7 The File Structure for Problems a-g.

a) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.7.

b) How many different data sources are likely to be used by the file you examined in problem a?

c) Given your findings in Problems a and b, how would a relational database environment help eliminate the data redundancy problems?

d) Given your answer to Problem c, how many tables would you use to substantially eliminate the data redundancy problems? What table structures would you recommend?

e) Given your answers to problem d, show the table contents...

Similar Documents

Free Essay

Bbc1

...Choose 1 answer - ANSWER D – A. Angry cats are wanting to be let outside. –WRONG TENSE should be “want” B. The hungry dogs have ate their breakfast. - WRONG TENSE should be “eaten” C. Yesterday, the teacher prepares the assignment. - WRONG TENSE should be “prepared” D. The children are ready to go to school. 2. Which sentence has the correct subject-verb agreement? Choose 1 answer ANSWER A – ignore the stuff between the commas A. The children, hushed by their teacher, try to keep quiet. B. The books, read by the student, is returned to their shelf. INCORRECT – plural “books” doesn’t match singular “is returned” C. The librarian, anxious to find the books, browse the stacks. Singular “librarian” does not match plural “browse” D. The student, bothered by the uproar, request less noise. Singular “student” does not match plural “request” 3. Which sentence has the underlined word spelled correctly? Choose 1 answer ANSWER A – B is spelled correctly but it’s the wrong use. A. The principal sent the student a letter of congratulations. B. The principle ate lunch with the students. INCORRECT – wrong version of word for sentence C. The prinsipal signs the final grade reports. INCORRECT – no ‘s’ D. The princepal earned minimal interest. INCORRECT – no ‘e’ 4. Classify each sentence according to whether it exhibits or does not exhibit parallelism. Select your answer from the pull-down list. ANSWER......

Words: 6519 - Pages: 27

Premium Essay

Business Management

... Knowledge 3 4.2 Skills 4 5. SYLLABUS 4 6. LEARNING METHODS 4 7. LEARNING MATERIALS & SUGGESTED TEXTS 5 8. LECTURE & SEMINAR SCHEDULE 9 LECTURE PROGRAMME 9 SEMINAR PROGRAMME 11 9. ASSESSMENT SCHEME 14 10. GUIDELINES ON HARVARD REFERENCING SYSTEM 26 11. INSTRUCTIONS FOR SUBMITTING YOUR WORK ELECTRONICALLY 27 12. ACADEMIC MISCONDUCT 27 13. REGULATIONS 28 14. MARKING SCHEME 29 15. GRADING SCALE 31 13. ASSESSMENT AND GRADING FEEDBACK FORMS 32 14. Lecture Slides 38 1. Welcome Welcome to Principles of Marketing. I hope you find this module a valuable learning experience. The challenges of providing superior customer value and gaining a competitive advantage have become crucial issues to a diverse range of companies. Delivering value and achieving a competitive advantage requires, among other things, a thorough understanding of markets, buyers and competition and an ability to match an organisation’s strengths to external opportunities. In this module students are introduced to a wide range of concepts covering the whole field of marketing. For students intending to specialise in marketing it will provide a valuable introduction, underpinning the more specialist studies later on in their degree...

Words: 8314 - Pages: 34

Free Essay

Capstone

...CHAPTER 1 THE PROBLEM AND ITS SCOPE INTRODUCTION Rationale of the Study Acquiring information is quasi difficult. Specifically, information that was secluded from general views. To puzzle out this problem, technology becomes an absolute must. In fact it can be used effectively in daily lives. The most essential contribution of technology to society is making the lives of people much easier and helping them achieve more what was previously impossible. The discovery of computers was the great function of modernity to make work easier, faster, and more precise for the humanity. Though technology may differ in various ways, but its uses are likely more advantageous. With technology, people find fast acquisition and availability of information. To have lived in this world for so many years without the use of computers just seem unthinkable or even unbelievable! (Stair and Reynolds, 2007). In today’s generation of rapid development, technology facilitates peoples’ lives and creates more comfort. It has remarkably improved the quality of life. Due to this transitory advancement, youngsters resort on finding information the easiest and most convenient way. It is in this era also that technology has affected society and its surroundings in a number of ways. In many societies, technology has helped develop more advanced economies. As organizations and entrepreneurs continue to operate in an increasingly competitive and global market place, workers in all business areas...

Words: 8842 - Pages: 36

Free Essay

Anabaptists

...of Christianity. Digging deeper will bring to light many groups coming together under the belief that the state church was no longer leading and teaching biblical theology. There were groups that popped up all across Europe in the wake of reformation lead by Martin Luther, John Calvin, and Ulrich Zwingli. Even before the time of the Anabaptist movement there was a high level of persecution for those who stood against the state church and the pope. There was a difference between what the reformers were doing and what the Anabaptists were doing. “The Reformers aimed to reform the old Church by the Bible; the Radicals attempted to build a new Church from the Bible.” There are also many great leaders from this radical group of Christians that need to be studied to know where this group was coming from. There is much more to this radical group known as the Anabaptists than meets...

Words: 4561 - Pages: 19

Premium Essay

Cause Marketing

...almost undifferentiated. At this time, creating an emotional connection with the customers seems most difficult task at hand. In the market place where customer and societal expectations are changing rapidly requiring constant innovation of new ideas, products and services, strategy and social responsibility provide the shortest route to an organization’s success. Therefore, cause branding provides an effective alternative to enhance brand equity by associating brand with an appealing cause. This project explores effectiveness of cause related marketing strategy and tries to find the answer to the question “How it impact to brand building?” It gives brief introduction to the concept of cause branding, its definition and difference between cause marketing and corporate philanthropy and corporate sponsorships. Then, it tells about the inception of cause marketing, its evolution into cause branding and need for cause related marketing, collected primary data analysis and secondary data examples which benefited from this marketing strategy. Introduction Creating brand equity is the most powerful weapon in a company’s armor to beat the competition. In the fiercely competitive market place of today where customer and societal expectations are changing rapidly requiring constant innovation of new ideas, products and services, strategy and social responsibility provide the shortest route to an organization’s success. In recent times, corporate social responsibility has gained......

Words: 4127 - Pages: 17

Premium Essay

Genpsy

...to fit into today's society, they want to look as better as possible due to the outside influences one has. People’s desire for physical beauty, while shaped and polished by the superficial media culture rather than just having a nice personality, actually has deeper roots in who they are. This desire for physical appearance is an original human feeling, like the desire for food, nurturing, or happiness according to Studies. In this times this even includes surgical procedures to correct perceived faults in the face or body they have been given. Before, only the rich and famous people or those with severe deformities, birthmarks and injuries would have any kind of cosmetic surgery. Now it’s becoming increasingly. And also before World War I, women were supposed to be soft and feminine, as in the case of the oft-referenced Rubens nude paintings. Now their culture worships jutting hipbones, protruding clavicles, and visible rib cages. Despite beauty's transience, there is no end to the things humankind will do in its name. Modern society marvels at the extremes these allegedly “primitive”...

Words: 3817 - Pages: 16

Free Essay

Toeic

...TESTS 100 TOEIC Preparation Tests Index ...................................................................................... Advanced Level 1. Bearing Information ..................................................................... 2. Cinemas ................................................................................. 3. Cliches ................................................................................. 4. Mistaken Identity ....................................................................... 5. Speaking: At the Station ................................................................ 6. Speaking: At the Supermarket ............................................................ 7. Speaking: At the Theatre ................................................................ 8. Speaking: The Broadcast ................................................................. 9. What comes next (the bill) .............................................................. 10. Accounts ............................................................................... 11. Advertising ............................................................................ 12. Agreements ............................................................................. 13. Applying for that Job .................................................................. 14. Are You in Debt? ....................................................................... 15. At the Computer ...................................

Words: 56150 - Pages: 225

Premium Essay

Supply Chain Management

...Abstract In today’s world, it is absolutely impossible to think of business operations without proper processes designed for supply chain management in any organization. In most firms, supply chain management refers to the ways logistics are handled in the company. Supply chain management is nothing but management of logistics and the process of eliminating general inefficiencies in the company. It refers to the processes of how the different suppliers and the whole network thereof are managed. The overall aim of supply chain management is to produce effective and efficient operations. The value of supply chain management goes up all the even more in retail chain organizations. This is due to the fact that every retail chain organization works with a number of suppliers at any given point in time. All retail firms have to make a conscious effort to integrate the logistics, distribution activities with the suppliers, and the manufacturer’s overall efforts. This study attempts to go through and systematically review the comprehensive processes for supply chain management in any retail chain organization. Also, it tries to undermine how the current technology and innovation techniques can be leveraged to improve the supply chain management processes and to make them more consumer-centric and efficient. This study has used the example of Wal-Mart, the leading global retail giant. This is a perfect example used to illustrate how supply chain management processes should be......

Words: 9986 - Pages: 40

Free Essay

Toic

...TESTS 100 TOEIC Preparation Tests Index ...................................................................................... Advanced Level 1. Bearing Information ..................................................................... 2. Cinemas ................................................................................. 3. Cliches ................................................................................. 4. Mistaken Identity ....................................................................... 5. Speaking: At the Station ................................................................ 6. Speaking: At the Supermarket ............................................................ 7. Speaking: At the Theatre ................................................................ 8. Speaking: The Broadcast ................................................................. 9. What comes next (the bill) .............................................................. 10. Accounts ............................................................................... 11. Advertising ............................................................................ 12. Agreements ............................................................................. 13. Applying for that Job .................................................................. 14. Are You in Debt? ....................................................................... 15. At the Computer ...................................

Words: 55440 - Pages: 222

Premium Essay

Hands on Database

...HANDS-ON DATABASE AN INTRODUCTION TO DATABASE DESIGN AND DEVELOPMENT Steve Conger Seattle Central Community College Prentice Hall Boston Columbus Indianapolis New York San Francisco Upper Saddle River Amsterdam Cape Town Dubai London Madrid Milan Munich Paris Montreal Toronto Delhi Mexico City Sao Paulo Sydney Hong Kong Seoul Singapore Taipei Tokyo Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Product Development Manager: Ashley Santora Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcaño Director of Marketing: Patrice Lumumba Jones Senior Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Production Project Manager: Renata Butera Creative Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Kheng Guan Toh/Fotolia, Inc Media Editor: Denise Vaughn Media Project Manager: Lisa Rinaldi Full-Service Project Management: Chitra Sundarajan/Integra Software Services Pvt. Ltd. Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2012 Pearson Education, Inc., publishing as Prentice Hall, One Lake Street, Upper......

Words: 70521 - Pages: 283

Free Essay

Project

...CST/2009/378 IN PARTIAL FULFILLMENT OF BACHELOR OF SCIENCE DEGREE IN COMPUTER SCIENCE/ INFORMATION TECHNOLOGY FACULTY OF NATURAL SCIENCES EXAMINATON CARITAS UNIVERSITY, AMORJI-NIKE ENUGU JULY 2013. i CERTIFICATION This is to certify that this project DESIGN AND IMPLEMENTATION OF ONLINE ENTRANCE EXAMINATION (A CASE STUDY OF CARITAS UNIVERSITY, ENUGU) was carried out by; -------------------------------------------- ---------------------- NAME OF STUDENT SIGNATURE ------------------------------DATE ii APPROVAL PAGE This is to certify that this research was carried out by Abi Thomas Augustine Reg. No: CST/2009/378 of the Department of Computer Science/Information Technology , Faculty of Natural Sciences Caritas University Amorji-Nike, Enugu State. ____________________ CHIZOBA EZEME (MRS) SUPERVISOR _______________ DATE _______________________ ARINZE NWAEZE (Ph.D) HEAD OF DEPARTMENT _______________ DATE ____________________ __ Dr. BONIFACE EKECHUKWU EXTERNAL EXAMINER _______________ DATE iii DEDICATION This work is dedicated to the Almighty God for giving me the knowledge, wisdom and understanding in the pursuit of my academic career. I also extend this to my late father Chief A. E. Abi, mum, brother and sisters for all you love. May God bless you all. iv ACKNOWLEDGEMENT I want to use this medium to express my immeasurable and inestimable gratitude to my supervisor Mrs Chizoba Ezeme, my able Head of department Dr. Arinze Nwaeze, my Late Father, Chief......

Words: 18414 - Pages: 74

Free Essay

Colonial Rulw

...CST/2009/378 IN PARTIAL FULFILLMENT OF BACHELOR OF SCIENCE DEGREE IN COMPUTER SCIENCE/ INFORMATION TECHNOLOGY FACULTY OF NATURAL SCIENCES EXAMINATON CARITAS UNIVERSITY, AMORJI-NIKE ENUGU JULY 2013. i CERTIFICATION This is to certify that this project DESIGN AND IMPLEMENTATION OF ONLINE ENTRANCE EXAMINATION (A CASE STUDY OF CARITAS UNIVERSITY, ENUGU) was carried out by; -------------------------------------------- ---------------------- NAME OF STUDENT SIGNATURE ------------------------------DATE ii APPROVAL PAGE This is to certify that this research was carried out by Abi Thomas Augustine Reg. No: CST/2009/378 of the Department of Computer Science/Information Technology , Faculty of Natural Sciences Caritas University Amorji-Nike, Enugu State. ____________________ _______________ CHIZOBA EZEME (MRS) DATE SUPERVISOR _______________________ _______________ ARINZE NWAEZE (Ph.D) DATE HEAD OF DEPARTMENT ____________________ __ _______________ Dr. BONIFACE EKECHUKWU EXTERNAL EXAMINER DATE iii DEDICATION This work is dedicated to the Almighty God for giving me the knowledge, wisdom and understanding in the pursuit of my academic career. I also extend this to my late father Chief A. E. Abi, mum, brother and sisters for all you love. May God bless you all. iv ACKNOWLEDGEMENT I want to use this medium to express my immeasurable and inestimable gratitude to my supervisor Mrs Chizoba Ezeme, my able Head of department Dr. Arinze Nwaeze, my Late Father,......

Words: 18416 - Pages: 74

Premium Essay

Tut Letter101/3/2015

...ENG2602/101/3/2015 Tutorial letter 101/3/2015 GENRES IN LITERATURE AND LANGUAGE: THEORY, STYLE AND POETICS ENG2602 Semesters 1 & 2 Department of English Studies IMPORTANT INFORMATION: This Tutorial Letter contains important information about your module. CONTENTS Page 1 INTRODUCTION .......................................................................................................................... 3 2 PURPOSE OF AND OUTCOMES FOR THE MODULE............................................................... 4 2.1 Purpose ........................................................................................................................................ 4 2.2 Outcomes .....................................................................................................................................4 3 LECTURER(S) AND CONTACT DETAILS................................................................................... 5 3.1 Lecturer(s) .................................................................................................................................... 5 3.2 Department ................................................................................................................................... 6 3.3 University ...................................................................................................................................... 6 4 MODULE-RELATED RESOURCES ..................

Words: 5933 - Pages: 24

Premium Essay

Telecommunication

...Md. Areef AIUB ID: 10-93465-1 Course Instructor: Dr. A. F. M. Masum Rabbani AMERICAN INTERNATIONAL UNIVERSITY - BANGLADESH “An analysis of Factors Influencing the Telecommunication Industry Growth in Bangladesh” A case study of Bangladesh Author: Abdullah Md. Areef AIUB ID: 10-93465-1 Course Instructor: Dr. A. F. M. Masum Rabbani Abstract Not very long ago, mobile were only used by the professional or it was considered as the device of luxury, and user for only voice call, but the scenario has completely changed. Now it’s a necessity of the life. As Bangladesh is a small country with large number of population, it’s an attractive market for business like the mobile operators. Customers of the market do display a strange need for communication through cell phones and are often noted to spend more money on making calls than they do on food. In terms of Social factors, the market is still thriving for more. Customers are still willing to try something new and because of lack of loyalty, customers are always ready for a new operator, hoping that call rates will fall even more which is a threat. The almost exponential growth in the Telecoms sector in Bangladesh in the last 5-10 years has had the same transformative impact on Bangladesh’s economy as the growth of Ready Made Garments and Remittances. As well as being the largest contributor to Foreign Direct Investment and tax revenues, the catalytic effect of rapid mobile penetration on increasing the quality of......

Words: 11596 - Pages: 47

Free Essay

Recruitment and Selection at Infosis

...Global Delivery Model (GDM), which emerged as a disruptive force in the industry leading to the rise of offshore outsourcing. The GDM is based on the principle of taking work to the location where the best talent is available, where it makes the best economic sense, with the least amount of acceptable risk. Infosys has a global footprint with 64 offices and 63 development centers in US, India, China, Australia, Japan, Middle East, UK, Germany, France, Switzerland, Netherlands, Poland, Canada and many other countries. Infosys and its subsidiaries have 130,820 employees as on March 31, 2011. Establishment: Infosys was founded on 2 July 1981 by seven entrepreneurs: N. R. Narayana Murthy, Nandan Nilekani, Kris Gopalakrishnan, S. D. Shibulal, K Dinesh, Ashok Arora, and with N. S. Raghavan officially being the first employees of the company. The founders started the company with an initial investment of INR 10,000. The company was incorporated as "Infosys Consultants Pvt Ltd." in Model Colony, Pune as the registered office. Now the...

Words: 13460 - Pages: 54