Relational Schema Design

Databases

This is the second of many milestones associated with the project. You will be using the ER diagram and problem statement you developed in the previous milestone in this assignment. You will refer back to the relational schema developed in this assignment in future milestones to a) Analyze the design for privacy and security issues, b) Design the software system and c) Develop and test the information system. This assignment has the following learning outcomes: ● To learn how to design a Relational Schema and specify entity-integrity and referential integrity constraints given the Entity-Relationship diagram, and the requirements of an information system. ● To learn how to apply the practice of relational schema design in a situation similar to those seen in the industry. ● To learn how to work within a team to resolve conflicts and accommodate varied design choices. This is a team assignment and is ideally done in a team of three to four students.

Sriram Mohan

Problem Statement & Entity Relationship Diagram

Databases

This is the first of many milestones associated with a 6 week project. You will refer back to the requirements and design developed in this assignment in future milestones to a) Implement the design, b) Analyze the design for privacy and security issues, c) Design the software system and d) Develop and test the information system. This assignment has the following learning outcomes: ●To learn how to draft the requirements of an information system project using a problem statement. ●To learn how to draft a problem statement using the Function- Form–Economy-Time Model (FFET) ●To learn how to design an Entity-Relationship diagram, given the requirements of an information system. ●To learn how to explain the requirements of an information system, in a model that enables a software engineer to understand the capabilities of the system. ●To learn how to design an information system and rationalize said design in a manner that enables a software engineer to implement the design in a relational database system. ●To learn how to apply the practice of information modeling in a situation similar to those seen in the industry. ●To learn how to work within a team to resolve conflicts and accommodate varied design choices This is a team assignment and is ideally done in a team of 3 or 4 students.

Sriram Mohan

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

Introduction to Entity Relationship Diagrams

Databases

This assignment on developing and interpreting Entity Relationship Diagrams has the following learning outcomes:

●Design an Entity-Relationship diagram, given the requirements of an information system.

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


●Design an information system and rationalize said design in a manner that enables a software engineer to implement the design in a relational database system.

●Apply the practice of information modeling in a situation similar to those seen in the industry.

This is an individual assignment.

Sriram Mohan