Engineering Homework Help. ACT Information Technology Discussion
Instructions:
1. Give examples of systems in which it may make sense to use traditional file processing instead of a database approach.
2. If you were designing a Web-based system to make airline reservations and to sell airline tickets, which DBMS Architecture would you choose? Why? Why would the other architectures not be a good choice?
3. Consider the ER diagram shown in Figure1 for part of a BANK database (also below for reference). Each bank can have multiple branches, and each branch can have multiple accounts and loans.
a. List the strong (non-weak) entity types in the ER diagram.
b. Is there a weak entity type? If so, give its name, its partial key, and its identifying relationship.
c. What constraints do the partial key and the identifying relationship of the weak entity type specify in this diagram?
d. List the names of all relationship types, and specify the (min, max) constraint on each participation of an entity type in a relationship type. Justify your choices.
4. Discuss the characteristics of relations that make them different from ordinary tables and files.
5. How can the key and foreign key constraints be enforced by the DBMS? Is the enforcement technique you suggest difficult to implement? Can the constraint checks be executed in an efficient manner when updates are applied to the database?
6. What is the FUNCTION operation? For what is it used? And present a practical example/ scenario.
7. Discuss the correspondences between the ER model constructs and the relational model constructs. Show how each ER model construct can be mapped to the relational model, and discuss any alternative mappings?
8. List the three main approaches to database programming. What are the advantages and disadvantages of each approach?
