This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Ryan Somma StudenID: 9989060874 Ryeguy123@yahoo.com Assignment #1 1) Explain why database design is important? The primacy of database design is most keenly illustrated by looking at how data was managed with File systems before the advent of relational databases, when data was stored in solitary files without standards across departments within organizations, making it difficult to produce reports compiling data from disparate data sources, and requiring data processing spets to write custom applications to generate reports. A poorly designed database can include all the problems a File System presents, were tables in the same RDBMS are not related properly, organized inefficiently, or organized in such a way as to allow for the same data to exist in multiple locations, providing an environment where the data may not get updated in one place after being updated in others. Good database design must facilitate the production of information from data in a relational database. It will provide table structures related in such a way as to allow using Structured Query Language (SQL) and RDBMS interfaces, so that users may manipulate...
View Full Document
This note was uploaded on 12/14/2010 for the course CIS CIS517 taught by Professor D during the Winter '11 term at Strayer.
- Winter '11