Week 3 Assignment 3
Assignment 3: University Database
Due Week 3 and account 120 points
A celebrated university has afresh implemented a alliance action that will crave it to accumulate their apprentice records. In adjustment to move forward, the bounded university will charge to advance a abstracts archetypal that will absorb apprentice annal and accomplish assorted abstracts abstract transform and amount (ETL) processes. Imagine that you accept been assassin as a database adviser to abetment in the development of a abstracts architecture action for the apprentice records.
You met with assorted university accountable amount experts and accept bent the afterward afterwards assuming assorted business assay processes:
Faculty groups are disconnected by amount competencies that the university offers. For example, there are groups such as the Art Faculty, Computer Technology Faculty, Language Faculty, and Science Faculty. Anniversary adroitness affiliate has an assigned Dean and is appointed to advise at one accurate campus and school. They are able to advise as abounding courses as required.
Courses are categorized by advance cipher and title. Certain courses accept prerequisites and the university has asked for this to be cataloged as well.
There are assorted schools aural anniversary campus. For example, the Los Angeles campus holds the afterward schools: Academy of Science, Academy of Law, and Academy of Computer Technology. Additionally, anniversary academy offers altered able abstraction programs such as Forensic Computer Science, Marine Biology, Business Management, and Civil Engineering to name a few.
The abstraction aisle for acceptance requires that they be enrolled in a specific able abstraction program. The able abstraction affairs requires the acceptance to complete a specific set of amount courses. The university additionally requires that an online brand book be available. The online brand book should appearance grades awarded to acceptance for specific courses and the appellation they completed the course.
The university identifies anniversary apprentice by his or her name, date of birth, social, and able abstraction program.
Using these findings, address a three to four (3-4) folio cardboard in which you:
Analyze the university’s requirements and accommodate a angle to adapt all the appropriate abstracts elements. The angle should accommodate the following:
Provide an Entity Accord Archetypal (ERM) that will call the abstracts anatomy that will abundance all abstracts elements. Note: The graphically depicted band-aid is not included in the appropriate folio length.
Describe any assumptions or limitations for anniversary relationship. For example, advisers are able to advise added than one advance or acceptance can alone be enrolled in one program.
Create the primary key and adopted keys application a UML Class diagram for anniversary table.
Suggest at atomic four (4) types of business intelligence letters that could advice the university in advance management, apprentice enrollment, or actual tracking. Abutment your acknowledgment by accouterment specific business functions that these letters could abetment admiral of the university.
As an another for development of the database, you are because outsourcing the functions above. Analysis the Internet and alternative media sources for vendors who advance agent and academy administration database systems.
Suggest three (3) vendors that developed and are employing able agent and academy administration database systems and abutment your affidavit to accept from one (1) of these three (3) vendors.
Compare and adverse the key aspects that anniversary arrangement offers. Examples of arrangement aspects accommodate but not bound to billow based, appraisement model, accessible source, etc.
Use at atomic three (3) affection assets in this assignment. Note: Wikipedia and agnate Websites do not authorize as affection resources.
Your appointment charge chase these formatting requirements:
Be typed, bifold spaced, application Times New Roman chantry (size 12), with one-inch margins on all sides; citations and references charge chase APA or school-specific format. Check with your assistant for any added instructions.
Include a awning folio absolute the appellation of the assignment, the student’s name, the professor’s name, the advance title, and the date. The awning folio and the advertence folio are not included in the appropriate appointment folio length.
Include archive or diagrams created in any blueprint or cartoon accoutrement with which you are familiar. The completed diagrams / archive charge be alien into the Word certificate afore the cardboard is submitted.
The specific advance acquirements outcomes associated with this appointment are:
Describe the role of databases and database administration systems in managing authoritative abstracts and information.
Recognize the actual development of database administration systems and analytic abstracts models.
Design and apparatus a database band-aid to break a proposed business problem.
Use technology and advice assets to analysis issues in the cardinal implications and administration of database systems.
Write acutely and concisely about capacity accompanying to the cardinal planning for database systems application able autograph mechanics and abstruse appearance conventions.
Click here to appearance the allocation rubric.
Order a unique copy of this paper