Question

Using Visio Pre-PatriotWeb, the University needed a Course Registration Database. You have been tasked with this...

Using Visio

Pre-PatriotWeb, the University needed a Course Registration Database. You have been tasked with this task and the following business rules have been given to you:

  • Students need to be tracked with the following information:
    • Name
    • First Enrolled Semester
    • First Enrolled Year
    • Major
    • GPA
    • Student Status (Full or Part)
  • Courses need to be tracked with the following information (think Course Catalog):
    • Course Number
    • Course Name
    • Course Description
    • Credits
    • Course Coordinator
  • The courses being offered per semester needs to be tracked as well with the following information (think what you see on PatriotWeb):
    • Course ID (like the CRN we are used to)
    • Course & Section Number
    • Semester
    • Year
    • Instructor
    • Meeting Day & Time
  • When a student registers for a class offering, that also needs to be tracked with the following information:
    • Registration Date
    • Registration Status (Enrolled or Waitlisted)
    • Final Grade of the Student
  • Courses can have many offerings (think about how many sections of MIS 303 there are)
  • However, each offering can only be linked to one course
  • A student can register for many course offerings per semester – up to six
  • Each offering can have many students registered in it

Paste your ERD image below. Please make sure it’s clear and visible. You can also include the Visio file as a backup.

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Snap

if you still have any Problem regarding this question please comment and if you like my code please appreciate me by thumbs up thank you.........

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use the following user stories to complete a SEQUENCE DIAGRAM in the questions which follow: 1....
Use the following user stories to complete a SEQUENCE DIAGRAM in the questions which follow: 1. As a student, I w ant to register for my next semester courses when registration opens so I can get the courses I need to graduate. 2. As a student, I will browse the Class Schedule on the University website to find my courses and make sure they are offered, do not conflict, and are not full. If I cannot get the course(s) I...
14.19. Suppose that we have the following requirements for a university database that is used to...
14.19. Suppose that we have the following requirements for a university database that is used to keep track of students’ transcripts: a. The university keeps track of each student’s name (Sname), student number (Snum), Social Security number (Ssn), current address (Sc_addr) and phone (Sc_phone), permanent address (Sp_addr) and phone (Sp_phone), birth date (Bdate), sex (Sex), class (Class) (‘freshman’, ‘sophomore’, … , ‘graduate’), major department (Major_code), minor department (Minor_code) (if any), and degree program (Prog) (‘b.a.’, ‘b.s.’, … , ‘ph.d.’). Both...
Question 2 (5 Marks) What can you say about the relationships between Courses and Subject, and...
Question 2 What can you say about the relationships between Courses and Subject, and Courses and Students? Will there be any problems in creating a Relational Database from your ER diagram? If there is, then describe how you will address this and re-draw the ER diagram. Question 3 Create the DDL statements to create the tables described in your modifies ER diagram in Question 2. Question 4 In your Database you created in Question 3, assume there is a student...
SQL Data: you can just copy paste it into mysql to. CREATE DATABASE University;USE University; CREATE...
SQL Data: you can just copy paste it into mysql to. CREATE DATABASE University;USE University; CREATE TABLE Student (  sid INT PRIMARY KEY,  name VARCHAR(20) NOT NULL,  address VARCHAR(20) NOT NULL,  major CHAR(2)); CREATE TABLE Professor (  pid INT PRIMARY KEY,  name VARCHAR(20) NOT NULL,  department VARCHAR(10) NOT NULL); CREATE TABLE Course (  cid INT PRIMARY KEY,  title VARCHAR(20) NOT NULL UNIQUE,  credits INT NOT NULL,  area VARCHAR(5) NOT NULL); CREATE TABLE Transcript (  sid INT,  cid INT,  pid INT,  semester VARCHAR(9),  year YEAR,  grade CHAR(1) NOT NULL,  PRIMARY KEY (sid, cid, semester, year),  FOREIGN KEY (sid) REFERENCES Student...
a gymnastic school with hundreds of students. It needs a database to track all the different...
a gymnastic school with hundreds of students. It needs a database to track all the different classes that are being offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance. Design a database for the following requirements: Students are given a student number when they join the school. This is stored along with their name, date of birth, and the date they...
Consider the following set of requirements for a UNIVERSITY database that is used to keep track...
Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students’ transcripts. This is similar but not identical to the database shown in Figure 1.2: a. The university keeps track of each student’s name, student number, Social Security number, current address and phone number, permanent address and phone number, birth date, sex, class (freshman, sophomore, ..., graduate), major department, minor department (if any), and degree program (B.A., B.S., ..., Ph.D.). Some user applications...
California University encourages professors to consider using e-textbooks instead of the traditional paper textbooks. Many courses...
California University encourages professors to consider using e-textbooks instead of the traditional paper textbooks. Many courses have adopted the new e-textbook option. Suppose that the random variable X represents the number of courses taken by a student during the Winter 20 semester at California University that provide an e-textbook option. The (partial) probability distribution for the random variable X is provided. X = # course with e-text option 0 1 2 3 4 5 Probability _____ _____ 0.30 0.25 0.15...
MySQL I have the following tables: Students(sid,first_name,last_name,birthday,major,zipcode) Students_Courses(sid,cid,year,semester,grade) Courses(cid,name,credits) use Students_Courses table to find the student...
MySQL I have the following tables: Students(sid,first_name,last_name,birthday,major,zipcode) Students_Courses(sid,cid,year,semester,grade) Courses(cid,name,credits) use Students_Courses table to find the student sid and course cid for whom took the same course more than one time. can you help me with my query select first_name,last_name,name from Students s, Courses c where s.sid,c.cid,ct in ( select sid,cid,count(*) from Students_Courses group by sid,cid having count(*) > 1);
Use a diagram to represent how this system works. The Western Pacific University Enterprise System keeps...
Use a diagram to represent how this system works. The Western Pacific University Enterprise System keeps track of data such as staff and student details, units and unit enrollment details, unit offerings, transcripts, and dormitory details. This system integrates processes from three different functional areas – student services, registrar’s office and student – in which an output of one functional area can be used as input for another functional area. The three sub-systems are based on the three functional areas;...
Discuss the following short case. You are the newly appointed Dean of the Business Department at...
Discuss the following short case. You are the newly appointed Dean of the Business Department at Polk State College. One of the decision areas that must be addressed at the start of each semester is whether there are a sufficient number of students enrolled in a class to warrant delivering that class. The present policy is that there must be 10 or more students enrolled or the class will be cancelled. The traditional student tuition is $12,000 for a semester...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT