Physical Database Design and Relational Algebra

Databases

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

One Week

Reading, Writing

Design

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.

N/A

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.