IST 210, Test 1 ,Solution (Fall 2010)

IST 210, Test 1 ,Solution (Fall 2010) - IST 210 Quiz 1 Fall...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
IST 210 Quiz 1 Fall 2010 Name _________________________________ Student no. __________ Instructions : There are NO allowable references for this examination. This examination is worth 100 points . You will have 75 minutes to complete the examination. Please place your name and ID on this page. (20 points) (Topic: Data Organization Design Process) Briefly (200 words maximum) explain the below diagram with the respect to Entity- Relationship Modeling (E-R) (7 Points), Normalization (BCN )(7 Points), and Structured Query Language (SQL (6 Points). (7 points) ERD helps to define and move from the conceptual model to the logical model. ERD help: o Understanding o Define the essential information o Serve as a visual guide to the organization o In planning of how to proceed (7 points) Normalization is applied to produce the logical data model o Main objectives of relational databases is to ensure that each item of data is held only once within the database: o Minimize the amount of storage space Conceptual design Logical design Physical design
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
o Simplify updating procedures o Ensure that data is accurate o Done by converting ERD into well-structured relational data model (6 points) SQL is the tool used to create the physical design 2. (20 points) (Topic: Entity-Relationship Modeling) Use the below scenario
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/10/2010 for the course IST 210 at Penn State.

Page1 / 9

IST 210, Test 1 ,Solution (Fall 2010) - IST 210 Quiz 1 Fall...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online