How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Scott Your Own Question

Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

What's A Matter University (good old Whatsamatter U) is developin

Customer Question

What’s A Matter University (good old Whatsamatter U) is developing a database to manage academic issues. You are asked to assist in the design of the database. Sketch the Entity-Relationship diagram for each of the following business needs.
1. The university is divided into several schools: business, arts and sciences, education, and applied sciences. Each school is administered by a dean who is also a professor. Each professor can be the dean of only one school, and a professor is not required to be the dean of any school. Data of interest regarding the school includes: school code and school name. Data of interest regarding the professor includes: ID number, specialty, rank, name, and email address.
2. Each school is comprised of several departments. For example, the school of business has an accounting department, a management department, a marketing department, etc. The smallest number of departments operated by a school is one, and the largest number of departments is indeterminate. Each department belongs to only a single school. Data of interest regarding departments includes: department code and department name.
3. Each department offers courses. For example, the management department offers courses such as Introduction to Management and Production Management. Each course is identified by a unique course number, a course title, and a course description. Data of interest regarding courses includes: course number, course title, course description, and credit hours.
4. Each semester, a number of courses (but not all courses) are offered. Any given course might be offered once or a number of times in the semester. Each course offering is uniquely identified by a CRN (course requirement number). Other information regarding the course offering includes: cycle (i.e. Monday-Wednesday-Friday, Tuesday-Thursday, etc), starting time (i.e. 8:00 am), duration (i.e. 50 minutes) and semester (i.e. Fall 2014).
5. Each department has at least one professor assigned to it. A professor is assigned to one and only one department.
Submitted: 1 year ago.
Category: Homework
Expert:  ratheeshravi replied 1 year ago.
Hi,
Thank you for posting the question in JA. I will help you with this.
I assume that the only solution required os Entity Relationship diagram and this is not specific to any database product (Oracle, SQLServer etc.)
Is it ok if I provide the diagrams by 21st?
Regards
Ratheesh