Top Research Professionals
The research experts and assignment help team consists exclusively of highly qualified graduate writers, each professional with in-depth subject matter expertise and significant experience in custom academic writing.
Boost Your Final Grades By Ordering Custom Writing Help!
For similar papers and sample answers; with a few clicks, Order your research paper, thesis, dissertation writing and other assignment help services
Posted: September 8th, 2022
Assignment 3.3
This assignment is worth 70 points and the full rubric is on the bottom of the page.
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.
80 – 89%
(56 – 62 points) Meets Expectations. The average score at UMUC is 85%, and a memo which meets expectations will earn this score. This type of memo will typically be reasonably easy to follow, with good writing style. It will contain a clear recommendation about whether to move to the flat file and at least three reasons supporting the recommendation. It will outline use case scenarios where relevant. It will also contain solid understanding of the relational database concepts and data management concepts we have covered in class, and will tie this case study into our class work. May include a small amount of outside research. Typographical and grammatical mistakes are few to none. All APA formatting is met.
0 – 79%
(0 – 55 points) Does Not Meet Expectations. This type of memo may not contain a clear recommendation about whether to move to a flat file format. It will contain fewer than three reasons supporting the recommendation, and may not contain use case scenarios. It shows incomplete or incorrect understanding of relational database and data management concepts. No outside research and weak ties into class work. May have typographical or grammatical errors, and may not follow APA formatting.
Why Choose our Custom Writing Services
We prioritize delivering top quality work sought by college students.
Discounted Pricing
Our custom writing services maintain the highest quality while remaining affordable for students. Our pricing for research papers, theses, and dissertations is not only fair considering the superior quality but also competitive with other writing services.
0% Similarity Index
We guarantee plagiarism-free, human-written content. Every product is assured to be original and not AI-generated. Our writers, tutors and editors are research experts who ensures the right formating and citation sytles are followed. To note, all the final drafts undergo rigorous plagiarism checks before delivery for submission to ensure authenticity for our valued customers.
How it works
When you decide to place an order with Dissertation Help, here is what happens: