#inf-322

INF322 / INF 322 / DATABASE MODELING

Database Modeling

After reading this week’s article, “Modeling for the Future,” expand on the subject of Database Modeling. There are several tools listed and reviewed in the article. Research these tools further, or identify other modeling tools, and write a 2-3 page, APA-style paper focused on one tool of your choice. You are allowed to compare tools, but apply your findings and comparison to your research as if you were selecting the tool for use at your employer. What are the benefits and the possible shortcomings of using the tool? How would this tool help you meet your database modeling needs? Be sure to integrate vocabulary from the text to demonstrate your understanding of concepts.

INF322 / INF 322 / WEEK 1 DQS DATABASE – RUNNING ACCESS

Everyone has had some experience with data. Even if you are new to the Database world you have this experience since your personal information is data in many places. List an example of a database and how you interact with that database. One example might be as a customer receiving monthly bills. Another example might be your personal information collected at a medical office. Respond to at least two of your classmates’ postings.

If you have not already done so, install Microsoft Access 2010 (this is a free 60-day trial for MS Office Professional 2010). In response to this forum, note that you have successfully installed the product and what you experienced in the install and as you first opened the tool. We will all start with a sample database to get familiar with Access in Week 2. If you have any issues or unexpected results, this is a great place to share your experience. Respond to at least two of your classmates’ postings .

INF322 / INF 322 / WEEK 2 DQS IMPROVED PROCESSES – INTERVIEWING THE USERS

Databases are set up to assist fix problems, improve procedures, or provide an advantage to the company. Do you have a situation which you can share where you think a Database helped/could assist improve a procedure at your work or at one more company with which you are acquainted? It can be for a new app or to substitute an existing app or procedure.

This week’s reading contained a section on interviewing the users. Why is this process important? Think about who uses the tool, what they use it for, and what is important for them to get the job done. Have you ever been involved in any of these types of interviews? If so, share your experience. Respond to at least two of your classmates’ postings.

INF322 / INF 322 / WEEK 3 DQS KEYS – DETERMINING SYSTEM REQUIREMENTS

Why is a Key important in a database? How does it help with Referential Integrity? Chapter 8 lists three compelling reasons why Keys are crucial to table structure. There is an example of a table and its’ key in Figure 8.2. Respond to at least two of your classmates’ postings.

Identify the database or process you would like to begin to think about for your future database design. After you have developed a database idea, you need to plan the interviewing of your users. Interviewing will give you a better understanding of user needs, wants, and desires, as well as help you to determine your system requirements. What questions should you ask? (L

INF322 / INF 322 / WEEK 4 DQS TABLE RELATIONSHIP – BUSINESS RULES

Chapter 10 discusses table relationships. Define one type of relationship (one-to-one, one-to-many, many-to-many and self-referencing relationships) and provide an example of this type of data relationship.

There's a good deal of info to take into consideration while planning company rules. Since you have read Chapter 11, consider a company rule from a position you have been hired at and use that in an instance. This might be about determining user access or field specific data, determining if a field is needed or if a field has got data validation. How effective was the use of the co

INF322 / INF 322 / WEEK 5 DQS VIEWS – BENDING THE RULES

There are three types of views. Pick one of them and provide a definition, an example of that type of view, and when you would use the view. If you have ever purchased anything online and returned to the vendor Web site, many views of data will be accessible when you login, including your previous orders, their catalog of product, and even your shipping and credit card information. Think of examples like this before you respond. Respond to at least two of your classmates’ postings.