ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 3 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 25 Apr 2017 My Price 8.00

ADVANCED DATA MODELING

Could anyone help me understand these two problems? I would certainly appreciate it.

Thanking you in advance,

 

 

ADVANCED DATA MODELINGCity College has three types of employees:Administrators,Professors, andStaF. Professors only teach,but some administrator may teach classes in addiTon to their administraTve duTes. For example, a Chairhas to teach 2 classes per semester, and a some deans have to teach one class per semester. A sta± is anon-administraTve and non-teaching employee. Administrators may include Chairs, Deans, Provosts, etc.²he College wants to keep track of the history of all itsadministraTveappointments, including dates ofappointment and dates of terminaTon. (HIN²: Tme variant data are at work!). ²he College is interestedto generate Tme-dependent reports (using SQL, of course) for the administrators such as“How many deans worked in the College of Business between January 1, 1960, and January 1,2016?“Who was the dean of the College of EducaTon in 1990?” etc., etc.Given that informaTon, create thecomplete ERDusing VISIO that contains allprimary keys,foreign keys,andmain a±ributes.

 

Attachments:

Answers

ComputerScienceExpert
(11)
Status NEW Posted 25 Apr 2017 08:04 AM My Price 8.00

-----------

Attachments

file 1493108207-Solutions file 2.docx preview (51 words )
H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------
Not Rated(0)