January 2021

1.Model a set of typical family relationships— spouse, father, and mother—in a single 3NF relation. Also include nonkey attributes name and birth date. Assume that each person has only one spouse, one father, and one mother. Show foreign keys with dashed underlining. 2. Many database management systems offer the ability to enforce referential integrity. Why […]

1.Discuss what additional information should be collected during requirements analysis that is needed for file and database design and that is not especially useful for earlier phases of systems development. 2.Find out what database management systems are available at your university for student use. Investigate which data types these DBMSs support. Compare these DBMSs based

1. Study your answer to Question 1. Verify that the relations you say represent the Petrie’s Electronics database are in third normal form. If they are, explain why. If they are not, change them so that they are. 2. The E-R diagram you developed in questions in the Petrie’s Electronics case at the end of

1.Using your answer to Question 2, select data types, formats, and lengths for each attribute of each relation. Use the data types and formats supported by Microsoft Access. What data type should be used for non intelligent primary keys? 2. Complete all table and field definitions for the Petrie’s Electronics case database using Microsoft Access.

1.The one decision for a relational database that usually influences efficiency the most is index definition. What indexes do you recommend for this database? Justify your selection of each index. 2. List and define the factors that are important to successful implementation efforts. 3.What are the deliverables from coding, testing, and installation?

1.Explain the testing process for code. 2. What is the difference between system documentation and user documentation? 3. List and define the various methods of user training. 4. Describe the delivery methods many vendors employ for providing support. 5. List the steps in the maintenance process and contrast them with the phases of the systems

1.What are the different types of maintenance and how do they differ? 2. Describe the factors that influence the cost of maintenance. Are any factors more important? Why? What types of measurements must be taken to gain an understanding of the effectiveness of maintenance? Why is tracking mean time between failures an important measurement?

1.Describe the process for controlling maintenance requests. Should all requests be handled in the same way or are there situations when you should be able to circumvent the process? If so, when and why? 2. What is meant by configuration management? Why do you think organizations have adopted the approach of using a systems, librarian?

1.Consider the reasons implementations fail. For at least three of these reasons, explain why this happens, if there is one (or more) type of implementation likely to minimize the occurrence, and if there is one (or more) type of installation more likely to induce failure for this reason. 2. What is the purpose of electronic

Use move-ahead-k to encode each of the strings abcddcbamnopponm and abcdmnopabcdmnop twice, with k = 1 and k = 2. Wait-c-and-move. An element of A is moved to the front only after it has been matched c times to symbols from the input stream (not necessarily c consecutive times). Each element of A should have a counter associated with it, to count the number