posted by .

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.

  • database -

    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).

  • database -

    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.

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. 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
  2. essay cont. to Mrs. Sue

    I disagree with Petre’s view that colleges don’t help students in real life situations. It is true that colleges mainly focus on teaching students on what’s written in books. However, colleges do offer classes and variety of …
  3. Access Database - computers

    I have to make a database to track university apartments in access. I am stuck trying to decide what type of tables and field names i should have. would it make sense to have a table for students including first, last names, address, …
  4. Grades

    I need some help on calculating my current high school GPA. So far, I've completed 8 classes per year (I'm a sophomore, soon to be junior), making that 16 classes total. I also took two middle school classes that count for high school …
  5. it 210 computer programming

    I need to generate an object oriented design for a system that keeps track of a DVD and CD collection. Identify each of the classes, associated data, and operations of the classes. Create the pseudo code for each of the classes and …
  6. crj216

    Define database and explain how you could use a simple database (like Microsoft Access or Microsoft Excel) to track criminal offenses in your local community. Discuss what criteria you would use to categorize offenses and why. Explain …
  7. 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 students …
  8. math

    4. Gregory teaches martial arts. He charges a one-time processing fee of $5.00 and the cost of the classes is shown below. Let x represent the number of classes and y represent the cost of classes. Based on this information, what will …
  9. English

    Correct the errors in these quotations. I Have this homework, I don't know if I'm in the right track... 1."This is the hardest class I've ever taken. It's also the most rewarding. The teacher sets the bar high and I think that forces …
  10. math

    Mr. Smith has 100 students in his Algebra classes. The grades of a quiz are normally distributed with a mean of 70 and a standard deviation of 4. Sally claims that 75 students scored between 66 and 74 on this quiz. Given that this …

More Similar Questions