International Human Resource ManagementFull description
Prepared for MIS 6326 by Sumit Sarkar
THE UNIVERSITY OF TEXAS AT DALLAS SCHOOL OF MANAGEMENT MIS 6326: 6326: DATABA SE MAN AGEMENT SYSTEMS SYSTEMS SPRING 2000 2000
CASE STUDY: ALUMNI DATABASE The Dean of the business school wishes to create an UTD family! consistin" of its "raduates and corpor corporatio ations ns that ha#e ha#e been been staunch staunch sup suppor porter terss of the School School of Mana"eme Mana"ement$ nt$ %indin" %indin" the e&istin e&istin" " database inade'uate in terms of pro#idin" him with the information he needs to achie#e his "oal( he wishes wishes to de#elop de#elop a new alumni alumni databas databasee for for the colle" colle"e$ e$ )e wants wants the new database database to capture capture all rele#ant rele#ant information on alumni of the colle"e colle"e and the corporate supporter supporterss of the colle"e$ colle"e$ To build a lon"*term lon"*term relationship with alumni( he wishes wishes to keep track of all alumni from each functional functional area +e$"$( MIS( ,cct"( %in( Mkt( etc$- of the colle"e( where they work +or ha#e worked in the past-( and any donations donations that they ha#e ha#e made to the colle"e$ colle"e$ Similarly( for corpor corporate ate supporters( supporters( the database database must capture all rele#ant information on donations made by each corporation$ Upon further inter#iews with the Dean( he has indicated the followin" specific re'uirements. /$
2$
3$ 7$ 5$ 6$
, report report that display displayss alumni informa information tion for a specif specified ied area area for a particula particularr year year +e$"$( +e$"$( /000 MIS MIS "raduates-$ "raduates-$ The report report should list( for the specified specified area area and year of "raduation( "raduation( each alumnus1s alumnus1s name( e*mail address( the de"ree earned +e$"$( S( MS( M,( Ph$D$( etc$-( work phone number( and home phone number$ number$ ote that a similar report report could be re'uired re'uired for for any area area and any "raduatin" year$ %or a specif specified ied city city +e$"$( +e$"$( )ousto )ouston-( n-( a report report listin" all alumni who li#e li#e in that city$ city$ The report report will display display the name of the city( city( and for for each alumnus in that city( city( their their name( name( hom homee addres address( s( email email address( work phone( and home phone$ , report report listin" listin" all corpor corporate ate donors donors who who ha#e ha#e donated donated a total total amount amount "reater "reater than 425($ 425($ The report will be sorted in descendin" order of the total donated amount$ , report report that displays displays all all donations donations made to to a particular particular 89: +8eneral +8eneral :ed"er:ed"er- account$ account$ The The ID of of the donor( as well as the date and amount of the donation must be displayed$ , report report listin" listin" all alumni alumni workin" workin" for a particula particularr compan company y +e$"$( +e$"$( ;oined the company( as well as( their >ob title and salary$ , report report that displays displays the emplo employm yment ent history history for for a particul particular ar alumnus$ alumnus$ The report report must show( show( for each employer that alumnus has worked for( the employer name( the most recent >ob title the alumnus had with that employer company +e$"$( ?ice*President-( the date the alumnus >oined the company( and the date the alumnus left the company +if applicable-$
Additional Information: Donations can be made to one of se#eral funds@ e&le funds are the Aolle"e1s 8eneral %und( the TI Scholarship %und( etc$ , company1s ID ID number is a B di"it number nu mber uni'uely identifyin" a particular company$ , company1s industry industry is a 3 di"it di"it code code represen representin" tin" whether whether a company company1s 1s P
•
THE UNIVERSITY OF TEXAS AT DALLAS SCHOOL OF MANAGEMENT MIS 6326: DATABA SE MAN AGEMENT SYSTEMS SPRING 2000
+6 Points. 27E27E/2/$ ,nswer the followin" 'uestions based on the A1%(' D"t","!e case study$ a$
Desi"n a report for each of the re'uirements identified in the case study +note that it is not necessary to do it in MS ,ccess-$ State e&plicitly any assumptions you make$
b$
%or each re'uirement +report-( draw an =ntity*
c$
%or each re'uirement( list the set of 'uestions you will ha#e to ask the user to #erify whether the assumptions you made are appropriate or not$
Note: I will re'uire different "roups to present their solutions to the abo#e case + A1%(' D"t","!e- in class on %ebruary 22( 2$ I su""est that you make at least two copies of your solution. one to turn in( and one or more for your own reference +I stron"ly recommend that each student keep a copy of the solution for their own record-$ There will also be a follow up assi"nment that will re'uire the solution to this problem$
P$"*t*e Ee$*!e! 411 'ot ,e #$"5e5 I su""est you attempt these indi#idually$ /$
