HomeworkLib
Question

We would like to develop a database to manage all the data relevant to students and...

We would like to develop a database to manage all the data relevant to students and faculty at Virginia Tech. For each department, we have a department ID and name. The students enroll in departments. Each student will have a hokie ID, birthdate, gender, photo in the system. The department will hire multiple faculty members to teach courses. Each faculty member will have faculty hokie ID, research (including papers, patents, etc), gender, birthdate. The department will determine (1) what courses will be offered, (2) what time is the course, (3) what is the classroom, (4) Fall semester or Spring semester or Summer (5) what year the course will be offered. For a specific course, the syllabus, course ID, course title, credits, need to be provided before the students can select it. After the final week, the grade of course will be added to the database for each student.    

Please develop an E-R diagram for this application.

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
We would like to develop a database to manage all the data relevant to students and...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Design an ER diagram for a database for the Emory College. Here are some facts about...

    Design an ER diagram for a database for the Emory College. Here are some facts about the college: The Emory College consists of a number of Departments (MathCS, Physics, etc) A department has a unique name, address, phone number and can have a number of faculty members. A faculty member has SSN, name, office, phone number and salary A department has one department chair with a starting date A department can teach a number of courses A course has a...

  • Suppose a local college has tasked you to develop a database that will keep track of...

    Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses. Database Design Diagram Use any drawing package or any other application you know such as Visio, Word, PowerPoint, or another tool to create the Database Design Diagram. Otherwise, you may draw the...

  • Create a database ER model using the following information please: A small university is in the...

    Create a database ER model using the following information please: A small university is in the process of creating its first database system, and you are the chief architect of this system. This university does not have majors, faculties, and departments, but it does have programs. A program usually has 5 courses (in real situation, a program usually has much more courses, but to make the test data preparation easier, we set this number as 5), For simplicity, all the...

  • Suppose that there are three relationships in a database: Student relationship: S(SNO, SNAME, AGE, GENDER, DEPT)...

    Suppose that there are three relationships in a database: Student relationship: S(SNO, SNAME, AGE, GENDER, DEPT) Enroll relationship: SC(SNO, CNO, GRADE) Course relationship: C(CNO, CNAME) Here, the abbreviation and their full name correspond as: SNO Student Id number DEPT Student department SNAME Student name CNO Course number AGE Student age GRADE Course grade for certain student GENDER Student gender CNAME Course name Query the following in T-SQL format: Query the id number of the students who at least enrolled C2...

  • Consider the Schema diagram for a university database a. Find the IDs of all students who...

    Consider the Schema diagram for a university database a. Find the IDs of all students who have taken all of the CMPSC courses. Use the division operation. b. Do the same operation as in problem a, using only fundamental operations. student takes ID course id sec id semester 1er 4112 dept_name tot cred grade advisor section course_id sec id semester year building TOOM_10 time_slof_id course course id title dept name credits department dept name building budget time slot time slot...

  • Questions of this part analyze the students’ understanding in analyzing the given scenario and practical skills...

    Questions of this part analyze the students’ understanding in analyzing the given scenario and practical skills to build Class diagrams studied in chapters 8, 10 and 12of IT242. The “SES” administration would desire to have a database system to keep track of students, instructors, courses, assessments, and grades. Read the following paragraph to answer the given questions. The system maintains courses’ information. For each course, the system keeps a unique course code, name and credit hours. Each course offered in...

  • Please build an Entity Relationship Diagram using the following information: Build a database for a regional...

    Please build an Entity Relationship Diagram using the following information: Build a database for a regional university in Western New York called Ithica South University. The university database administrator needs to keep track of the students that attend the university, the courses offered by the university, and the university employees. Ithica tracks the first and last name of each student, as well as their target degree. The university keeps track separately of two subclasses of students, as students are either...

  • We aim to analyze students’ results in exams. The designer advocated a mixed approach. On the...

    We aim to analyze students’ results in exams. The designer advocated a mixed approach. On the one hand, he relies on the study of the analytical requirements requested by the university and by a committee that examines the results, and on the other hand by examining the data source model described by the relational database of exams. Below is a partial description of this database  STUDENT (STD-NO, FName, LName, Birth-Date, Gender, Housing, Tel, ID-FAC# FACULTY (ID-FAC, Name, Short-Name, Address, MODULE (ID-CORS,...

  • This is database system concept. 1.Find the ids of instructors who are also students using a...

    This is database system concept. 1.Find the ids of instructors who are also students using a set operation. Assume that a person is identified by her or his id. So, if the same id appears in both instructor and student, then that person is both an instructor and a student. Remember: set operation means union, intersect or set difference. 2.Find the ids of instructors who are also students using the set membership operator. 3.Find the ids of instructors who are...

  • 4. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you change the FacultyName field from 25 characters

    Problems and Exercises 1 through 9 are based on the dass scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.4. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the Student table?b. How would you remove the Registration table?c. How would you change the FacultyName field from...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT