This references the University database in Assignment 3.2. The university database contains several entities and several relationships between them.

Your manager wants to investigate moving to a simpler, more streamlined way of doing business. She has asked you to make a flat file with an alternate arrangement of the student data. Use your database and populate it with the first five students in the database. You can use any criteria you like to define "first." If you have questions about some of the fields, make sure include those in your memo. In the meantime, assume what you need to assume to generate the fields.

The flat file should include columns for:

• Student first and last name
• Student major
• Student GPA
• Course number, description, and units
• Offering term
• Faculty first and last name

You have some concerns about moving your entire university operations out of SQL to this flat file format.

Write your boss a memo, outlining any concerns or hesitations you have about moving to this format for management of your data. Include the pros and cons of the relational database format and the flat file format. Be sure to think critically, and include any problematic use case scenarios.

Submit your memo and within the memo include a table or screenshot showing the first five students' information in the flat file you generated. Append any .SQL or .csv flat files to this submission, and also make sure you paste your first five students' worth of flat file information into the body of your memo as a screenshot or table.

A page target of 1-2 pages is suggested; there are no length requirements or restrictions.

Rubric:

Score

Definition

90 - 100% (63-70 points)

Exceeds Expectations. These memos are really exceptional. They meet all the criteria of the "meets expectations" memo, and go beyond in some meaningful way. The "beyond" may be in very illustrative and detailed use case scenarios, critical thinking regarding additional components of databases such as security, or it may be in additional background research to provide additional perspectives. The business case is clear and easy to follow. Demonstrates mastery of the data management and SQL techniques we have covered in class.