EssayproSolutions

(Solved) : Use Microsoft Office Design Relational Database System Shows Transactions Within Theuniver Q37224087 . . .

Use Microsoft Office to design a relational database system thatshows transactions within theUniversity of the PotomacAdministration, staff, faculty,HR, financial aid, books store,library and students’ services. The database must contain thefollowing in order to satisfy the framework of this exam.

1. There must be one actor in the database to maintain theadministration’s information
2. There must be one actor in the database to maintain the staff’sinformation
3. There must be one actor in the database to maintain thefaculty’s information
4. Students actor will contain student’s information
5. One actor to host the library contents
6. One actor to hold the book store contents
7. One actor for the HR department
8. One more actor to maintain financial aid departmentinformation
9. Create a relationship that illustrates the transactions betweenthe actors as follows:
   1. Faculty course assignments transactions between administrationand faculty
   2. Staff functional transactions between administration andstaff
   3. Students course registration system will consist of thefollowing:
   1. The main process to Handle all the Student Registrationtransactions
   2. Some subprocesses to receive and transform Students,Administration, faculty, books supply, and financial aidinformation activities during and after registration.
   3. There will also be data stores to decouple the processes sothat receiving processes do not have to respond immediately duringdata transfer
   4. The System will contain source and sink to input and outputdata.
   4. The overall system should interrelate for the proper flow ofinformation within the Potomac Academic System

Expert Answer

Answer to Use Microsoft Office to design a relational database system that shows transactions within theUniversity of the Potomac …