Essay on Database design process

Step 2. Data Analysis: The data will be analyzed to determine database modeling. Step 3. Database normalization: Fields and

For this assignment, you will NOT create a database.  You will list the type of data you want to collect, group it accordingly, break it into field and determine attributes.  Think about how the different pieces of data relate to one another and what purpose they serve.  You may use Excel, Word, or Visio for this assignment.

In order to complete this task, I will need the data that needs to be inserted into the table, and how the information will be used.

- Tables are useful in showing relationships and making comparisons. They should have title, row, column headings, population, source and explanations.

* Per the text, when databases are developed, they are modeled around business rules, so they accurately support a business function or operation.

2. using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths; and

Read the textbook. Do research on databases. All answers should be analytical, using IGEA and MLA. Please use own words/original thought, not regurgitation of facts. This is the expectation all year.

To answer each question, darken the circle corresponding to your answer using a pencil. If you decide to change your answer, please erase your original answer completely and darken your new answer.

3. Search for an article on Database Design. Does it have any discussion of information gathering? If so, what steps does it suggest?

Hence, this session has enhanced my understanding about normalization and how essential to create a data that is well organized with the relationships clearly defined and established between the tables (based on the business rules) in order to eliminate data redundancy and inconsistency.

Understanding the business model of enterprise and identifying the entities of that model is the first step in setting up database. Requirements analysis includes tasks of determining the needs or conditions to meet. Requirement specification document will be generated at the end of this step.

Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is

Spellman University had requested that I develop a database for their college. The purpose of the database will be to track the students and the courses. There also will be a place in the system to track the instructors teaching each course. There are many things to be considered in composing this database. This paper will outline the entities, attributes for each entity, the type of relationship, constraints, some business rules, and the conceptual and physical models.

First our team will talk about how Microsoft Access was used to create these tables by Huffman Trucking Database. Then how we used the tables with made up information to be tested on. Then on how we used forms in the maintenance database system. While the creation of relationships and normalization is explained in the process of using queries to search the database (University of Phoenix, 2007).

Example 1 – Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment: