database

University XYZ needs a database that keeps track of students, what classes they taken and the grades for each of the classes. In addition, they need to know what instructors are on staff and the courses they are approved to teach. It is necessary to track rooms for each campus including capacities as well as special facilities for each room.

  1. 👍 0
  2. 👎 0
  3. 👁 61
  1. Review the solution .pdf file in Doc Sharing, and Adjust your ERD in Visio to look like this one.

    This project is due in Week 4 and is worth 75 points.


    Now we will convert our conceptual model into a logical model. Using Microsoft Access, perform the following steps.


    For each entity listed in the Solution file, create a table in Access.
    Add primary keys for each table.
    Set column properties for unique constraints.
    Update the datatype for the attributes to enforce the domain constraints of the data.

    Dates should have a date datatype.
    Surrogate keys should be autonumber.
    Numeric should have a numeric datatype.
    Character data should have a character datatype.
    Under Database Tools, create the relationships, as appropriate.
    (All relationships should have referential integrity and the cascade update enabled.)
    Add several rows of data for each table.
    Add column constraints, as indicated.
    Campus name should be ONLINE or the campus name.
    Student name shall be not null.
    Course credit hours must be between 1 and 4.
    Course name must be unique and not null.
    Instructor last name and first name should not be null.
    Grade should be one of these values: A, B, C, D, F, I, W, or E (Enrolled).

    1. 👍 0
    2. 👎 0
  2. If you need help, you could post the suggested table names and the data each table contains.

    Remember this is an occasion to practise what you have learned in your course, and you will need this knowledge / competence to pass your exam, and eventually solve a customer's problem during your career.

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. statistics

    Suppose that on a certain examination in advanced mathematics, students from University A achieve scores which are normally distributed with a mean of 625 and a variance of 100, and that students from University B achieve scores

    asked by Anonymous on August 10, 2014
  2. Statistics

    80. Florida State University has 14 statistics classes scheduled for its Summer 2013 term. One class has space available for 30 students, eight classes have space for 60 students, one class has space for 70 students, and four

    asked by Howard on March 13, 2015
  3. math

    There are 37 accounting classes with 26 students in each class. Estimate the total number of students in the accounting classes. A) 1,200 students B) 900 students C) 1,600 students D) 1,500 students

    asked by lyric on September 30, 2007
  4. Technolgy

    A _________ is a way for students to keep track of information during research Credible Website Search log** Boolean operator online database

    asked by Shalee ^~^ on September 29, 2015
  5. Ed. Tech

    A blank is a way for students to keep track of information during research. A. Credible website B. Search log C. Boolean operator D. Online database Is the answer D?

    asked by Gwen on September 17, 2014
  6. college

    Do students at various universities differ in how sociable they are? Twenty-five students were randomly selected from each of three universities in a region and were asked to report on the amount of time they spent socializing

    asked by Karen Johnson on July 17, 2010
  7. math help

    A survey was done recently by the Royal Bank with Ipsos Reid (reported in Globe and Mail Aug 16 2010) about financial issues that university students face. (Data used here is based on that survey, but randomized to be still within

    asked by jaz on October 2, 2010
  8. stats

    A survey was done recently by the Royal Bank with Ipsos Reid (reported in Globe and Mail Aug 16 2010) about financial issues that university students face. (Data used here is based on that survey, but randomized to be still within

    asked by jaz on October 2, 2010
  9. statistics

    The Dean of a university claims that no more than 10% of the students drop out of university. She chooses a random sample of 500 students and decides that she will accept the claim only if no more than 25 of the 500 students drop

    asked by Anonymous on March 27, 2015
  10. Statistics

    A planner wants to determine the percentage of students who will attend summer classes. She surveys 32 students and finds that 12 will return for summer classes. Construct a 90% confidence interval estimate for the proportion of

    asked by Judy on December 12, 2011

More Similar Questions