<![CDATA[Incorporating Communication Outcomes into the Computer Science Curriculum]]> http://cs-comm.lib.muohio.edu/items/browse?tags=Algebraic+Operators&output=rss2 Mon, 18 May 2020 19:06:12 -0400 millarj@muohio.edu (Incorporating Communication Outcomes into the Computer Science Curriculum) Zend_Feed http://blogs.law.harvard.edu/tech/rss <![CDATA[Relational Schema Design]]> http://cs-comm.lib.muohio.edu/items/show/51

Title

Relational Schema Design

Course

Databases

Abstract

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.

Author

Sriram Mohan

Genre

Data Analysis, ER Diagram, Decisions, Schema

Assignment Duration

One Week

Communication Skill

Reading, Writing, Teaming

Technical Skill

Design, Design Specification, Normalization, Requirements Analysis

Workplace Scenario

As a software engineer you will often be required to design the relational schema for an information systems and specify entity-integrity and referential integrity constraints based on the entity relationship diagram (designed as a part of project milestone 1) and the problem statement (written as a part of project milestone 1). Please note that your relational schema must have the ability to store the required data in an efficient manner without any duplication.

A critical ability while working within a team is to develop an ability to manage conflicts, accommodate different design decisions, and manage conflicting client requirements. This milestone helps you apply these abilities in a real life situation.

Team Size

3

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.
333RHIT-ProjectAssignmentFramework5.docx
]]> Tue, 24 Jul 2012 16:50:08 -0400 <![CDATA[Physical Database Design and Relational Algebra]]> http://cs-comm.lib.muohio.edu/items/show/23

Title

Physical Database Design and Relational Algebra

Course

Databases

Abstract

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.

Author

Sriram Mohan

Genre

ER Diagram, Schema, Decisions

Assignment Duration

One Week

Communication Skill

Reading, Writing

Technical Skill

Design

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

N/A

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.
333RHITAssignmentFramework2.doc
]]> Tue, 24 Jul 2012 16:15:55 -0400