ZuoTi.Pro
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

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

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

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

  • Deck Scudder, the chairperson of the information technology department at the University of Denver, needs to...

    Deck Scudder, the chairperson of the information technology department at the University of Denver, needs to create a database to keep track of all the courses offered by the department. In addition, Deck would like the database to include each instructor’s basic contact information, such as ID number, name, office location, and phone number. Currently, Deck has nine instructors (seven full-time faculty members and two adjuncts) in the department. For each course, Deck would like to keep track of the...

  • Read, read and read and then think about that you can create perfectly an enhanced ERD...

    Read, read and read and then think about that you can create perfectly an enhanced ERD for the following description. with making sure to include all kind of entities, attributes, and correct cardinality in relationships between entities. Never forget foreign keys. You need to build a database for the Good College. The College database administrator needs to keep track of the students that attend the College, the courses offered by the college, and the college employees. College tracks the first...

  • Develop a conceptual ER diagram for the above database description, using appropriate syntaxes, and showing cardinalities...

    Develop a conceptual ER diagram for the above database description, using appropriate syntaxes, and showing cardinalities and key attributes. Consider the partial description for a UNIVERSITY database below: A university is organized into colleges, and each college has a unique name, a main office and phone, and a particular faculty member who is dean of the college. Each college administers a number of academic departments. Each department has a unique name, a unique code number, a main office and phone,...

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
ADVERTISEMENT