Develop a database broker framework to implement a persistence mechanism for the domain objects involved in the use case dealt with in Question 2. 

a. Specify the attribute types, visibility, and operation signatures for the most complex domain object involved in Question 2. (Hint: consider ALL use cases in which the domain object class participates.)

b. Map the information required by the chosen domain object class onto a set of relational database tables in third normal form. Specify the table design. 

c. For all the associations that exist for the chosen domain object class, discuss how referential integrity can be maintained.

d. Design ‘persistence layer' classes to support interaction between the object oriented case study application and a relational database.

i. Specify the attributes and operations for these persistence layer classes.

ii. Modify the sequence diagram you developed for Part B to show interactions with the classes of the persistence layer. Also show interactions between the persistence layer and the database.

Posted Date: 4/13/2013 1:12:01 AM | Location : United States

Ask an Expert

Related Discussions:- Data management, Assignment Help, Ask Question on Data management, Get Answer, Expert's Help, Data management Discussions

Write discussion on Data management
Your posts are moderated

Write your message here..

Related Questions

Chapter 1 - Profile for the Organization, Chapter 1 - Profile for the Organ... Chapter 1 - Profile for the Organization You have to select an organization of your choice and assume that you work for that organization. Now you must prepare a brief profile of t

Guidelines for creation of table, Guidelines for creation of table: ... Guidelines for creation of table: Table name should begin with an alphabet. In table name, single quotes and blank spaces are not allowed. Reserve words of that DBM

Explain cnt in the respects of qbe, Explain CNT in the respects of QBE ? ... Explain CNT in the respects of QBE ? CNT: It is one of the aggregation commands given in QBE. It is used to identify number of tuples

Write short notes on relational model, Write short notes on relational mode... Write short notes on relational model The relational model uses a collection of tables to show both data and the relationships between those data. The relational model is an ex

Time stamp ordering, explain in detail about time stamp orderting/ explain in detail about time stamp orderting/

A Biological Database on Viruses, How to create a biological database based... How to create a biological database based on viruses. How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain,

Modular growth, Modular growth: In distributed environments, it is simple t... Modular growth: In distributed environments, it is simple to expand. Latest sites can be added to the network without affecting the operations of other sites, as they are somewhat

Define two-phase locking protocol, Define two-phase locking protocol. A... Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

Explain p command in the respect of qbe, Explain P command in the respect o... Explain P command in the respect of QBE? P: It is the command in which is used to print (logically display) the value of the attribute in whose cell it is writ

What is a primary key, What is a primary key? Primary key is chosen by ... What is a primary key? Primary key is chosen by the database designer as the principal means of identifying an entity in the entity set.