Physical Database Design and Relational Algebra




This assignment on converting ER diagrams to a Physical Database Design and writing Relational Algebraic expressions has the following learning outcomes:

●Translate the conceptual representation of a database into a physical implementation on a target database management system.

●Identify entities, constraints and relationships captured by an entity relationship diagram

●Employ Relational Algebra to access data stored in a relational database system.

●Describe design choices with respect to physical database design and rationalize that in a manner that enables a software engineer to implement the design in a relational database system.

●Apply the practice of physical data design in a situation similar to those seen in the industry.

●Interpret a logical design of an information system to identify, label and verify the constraints imposed on the system.

This is an individual assignment.


Sriram Mohan


ER Diagram, Schema, Decisions

Assignment Duration

One Week

Communication Skill

Reading, Writing

Technical Skill


Workplace Scenario

As a software engineer you will often be required to translate a conceptual design of an information system into a physical implementation on a target database system. It is your responsibility to ensure that the information system has the ability to store the required data in an efficient manner without any duplication. Once the system has been implemented, you will be responsible for designing efficient canned transactions that can be utilized by end-users. A working knowledge of Relational Algebra will be useful in designing queries that can be optimized and executed in an efficient manner.

Team Size


Additional Information

Students are expected to follow ER to Relational Schema design rules and naming conventions as prescribed in the Course Text and as also covered in the class.



Sriram Mohan, “Physical Database Design and Relational Algebra,” Incorporating Communication Outcomes into the Computer Science Curriculum, accessed June 18, 2018, http://cs-comm.lib.muohio.edu/items/show/23.


Creative Commons License

File: 333RHITAssignmentFramework2.doc


Allowed tags: <p>, <a>, <em>, <strong>, <ul>, <ol>, <li>