Please answer all 3 questions below with 250 words or more. Use refs
1. Database normalization is a very important process in designing and organizing tables (relations) and their columns (attributes or fields) in a relational database. Therefore, what are the consequences (problems) if a database was designed without it? Would the database still work?
2. Pretend that you are building a Web-based system for the admissions office at your university. The system will be used to accept electronic applications from students. All the data for the system will be stored in a variety of files.
Question: Give an example using the preceding system for each of the following file types: master, look-up, transaction, audit, and history. What kind of information would each file contain and how would the file be used?
[Sources: "CHAPTER 11: DATA STORAGE DESIGN" - Alan Dennis, Barbara Haley Wixom, and Roberta M. Roth (2012). System Analysis and Design, Fifth Edition, John Wiley & Sons.]
3. A major public university graduates approximately 10,000 students per year, and its development office has decided to build a Web-based system that solicits and tracks donations from the university's large alumni body. Ultimately, the development officers hope to use the information in the system to better understand the alumni giving patterns so that they can improve giving rates.
Question:
1. What kind of system is this?
2. What different kinds of data will this system use?
3. On the basis of your answers, what kind of data storage format(s) do you recommend for this system?
[Sources: "CHAPTER 11: DATA STORAGE DESIGN" - Alan Dennis, Barbara Haley Wixom, and Roberta M. Roth (2012). System Analysis and Design, Fifth Edition, John Wiley & Sons.]