Posted: September 8th, 2022

Task three.three

This task is price 70 factors and the total rubric is on the underside of the web page.

This references the College database in Task three.2. The college database incorporates a number of entities and a number of other relationships between them.

Your supervisor desires to analyze shifting to a less complicated, extra streamlined manner of doing enterprise. She has requested you to make a flat file with an alternate association of the coed information. Use your database and populate it with the primary 5 college students within the database. You should utilize any standards you prefer to outline “first.” When you have questions on among the fields, make certain embrace these in your memo. Within the meantime, assume what you could assume to generate the fields.

The flat file ought to embrace columns for:
• Scholar first and final identify
• Scholar main
• Scholar GPA
• Course quantity, description, and models
• Providing time period
• College first and final identify

You could have some issues about shifting your total college operations out of SQL to this flat file format.

Write your boss a memo, outlining any issues or hesitations you’ve about shifting to this format for administration of your information. Embrace the professionals and cons of the relational database format and the flat file format. Make sure you suppose critically, and embrace any problematic use case situations.

Submit your memo and inside the memo embrace a desk or screenshot displaying the primary 5 college students’ data within the flat file you generated. Append any .SQL or .csv flat information to this submission, and in addition ensure you paste your first 5 college students’ price of flat file data into the physique of your memo as a screenshot or desk.

A web page goal of 1-2 pages is recommended; there are not any size necessities or restrictions.

Rubric:

Rating Definition
90 – 100%
(63-70 factors) Exceeds Expectations. These memos are actually distinctive. They meet all the standards of the “meets expectations” memo, and transcend in some significant manner. The “past” could also be in very illustrative and detailed use case situations, crucial pondering relating to extra parts of databases equivalent to safety, or it might be in extra background analysis to offer extra views. The enterprise case is obvious and simple to observe. Demonstrates mastery of the info administration and SQL strategies we’ve coated at school.
80 – 89%
(56 – 62 factors) Meets Expectations. The common rating at UMUC is 85%, and a memo which meets expectations will earn this rating. This kind of memo will usually be fairly simple to observe, with good writing model. It is going to comprise a transparent suggestion about whether or not to maneuver to the flat file and a minimum of three causes supporting the advice. It is going to define use case situations the place related. It is going to additionally comprise strong understanding of the relational database ideas and information administration ideas we’ve coated at school, and can tie this case research into our class work. Could embrace a small quantity of out of doors analysis. Typographical and grammatical errors are few to none. All APA formatting is met.
zero – 79%
(zero – 55 factors) Does Not Meet Expectations. This kind of memo might not comprise a transparent suggestion about whether or not to maneuver to a flat file format. It is going to comprise fewer than three causes supporting the advice, and will not comprise use case situations. It reveals incomplete or incorrect understanding of relational database and information administration ideas. No outdoors analysis and weak ties into class work. Could have typographical or grammatical errors, and will not observe APA formatting.

Order | Check Discount