Development of an ER Diagram and Database Implementation Free Solution

Question: To give you practical experience in using Entity-Relationship and Relational Database modeling techniques. Project Specification Alan Counting, Edward Quals and Peter Rofit are in partnership in an accounting practice, CQR. The practice specialises in taxation, auditng and financial advice for small to medium sized clients. They started the practice in 2005 and it has grown to now employ 25 people. These employees include other accountants and office staff. Alan, Edward and Peter believe the practice is headed for a period of significant growth and have come to you to help them redevelop their Client Billing (CB) system so that it copes better with their workflows and supports future growth opportunities. Answer: ER Diagram Relational Data Structures SERVICE CLIENT Sector Employee BILLING RATE DOMAIN QUALIFICATION Normalisation References: Batini, C., Ceri, S., Navathe, S. (1989). Entity Relationship Approach. Elsevier Science Publishers BV (North Holland). Batmaz, F., Hinde, C. J. (2006). A diagram drawing tool for semiautomatic assessment of conceptual database diagrams. Chen, Y. L. (2009). Entity-Relationship Diagram. In Modeling and Analysis of Enterprise and Information Systems (pp. 125-139). Springer Berlin Heidelberg. Coronel, C., Morris, S., Rob, P. (2009). Database systems: design, implementation, and management. Cengage Learning. Elmasri, R. (2008). Fundamentals of database systems. Pearson Education India. Kifer, M., Bernstein, A. J., Lewis, P. M., Lewis, P. M. (2005). Database Systems: An Application-oriented Approach: Introductory Version. Pearson/Addison Wesley. zsu, M. T., Valduriez, P. (2011). Principles of distributed database systems. Springer. Tzitzikas, Y., Hainaut, J. L. (2005). How to tame a very large ER diagram (using link analysis and force-directed drawing algorithms). In Conceptual ModelingER 2005 (pp. 144-159). Springer Berlin Heidelberg. Yousefi'zadeh, H. (2005). U.S. Patent No. 6,950,848. Washington, DC: U.S. Patent and Trademark Office.