ZuoTi.Pro
Question

1. A college database keeps information about: Professors- ID, Name, Title . Courses - Code, Name . Software products- Name, description For each semester, the college wants to record which professor taught which course and what software was used for it. A particular software product can be used in different courses; a professor can teach more than one course and use multiple software products; a course can be taught by different professors For each software product there is a professor who is in charge of it. A professor can be in charge of more than one software product. . h ra defined by Number, Name, and Unit

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

Homework Answers

Answer #1

ns) tRen data 0 t pro Pe ssDrs 1O, Name Counkes- Code, loame tfor Cach Perrester 米 Per Each Software produce P Code Nams Nama Profes Sor 1D Soltuwathe Produc Seme stes- c professor 1o Semestm No Counse Cods. eCounse lode

0 0
Add a comment
Know the answer?
Add Answer to:
1. A college database keeps information about: Professors- ID, Name, Title . Courses - Code, Name...
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

  • 1) A university database contains information about professors (identified by emp_id) and courses (identified by course_id)....

    1) A university database contains information about professors (identified by emp_id) and courses (identified by course_id). Professors teach courses. Each of the following situations concerns the Teaches relationship set. For each situation, draw an ER diagram that describes it (assuming no further constraints hold). a) Professors can teach the same course in several semesters, and each offering must be recorded. b) Professors can teach the same course in several semesters, and only the most recent such offering needs to be...

  • 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 following relations for a database that keeps track of student enrollment in courses and the books adopted for each course.

    Question: Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course. 1- Draw an ER diagram of ONLINE COURSE REGISRATION database, that captures all the given below requirements. Specify key attribute(s) of each entity set. For each relationship set, specify structural constraints and participation constraints. a. For each USER, the portal maintains user ID, Name, E-mail. Each user has a unique ID. Name is a Composite attributes with Frame, Midname,...

  • At a college, the college offers courses. For each course, one or more sections can be...

    At a college, the college offers courses. For each course, one or more sections can be offered. A section is only for one course. A section is identified by CourseID and SectionID combined. A section is taught by only one instructor. An instructor can teach many courses. Assume you are doing this for the current semester and are not worried about past or future semesters. a. Identify the entities for this college. b. Identify the relationships between entities and the...

  • Consider the following relations for a database that keeps track of student enrollment in courses and...

    Consider the following relations for a database that keeps track of student enrollment in courses and books adopted for each course. -------------------------------------------------------------------------------------------------------- STUDENT(Ssn,Name,Major,Bdate) COURSE(Course#,Cname,Dept) ENROLL(Ssn,Course#,Quarter,Grade) TEXTBOOK(Book_isbn,Book_title,Publisher,Author) BOOK_ASSOC(Course#,Quarter,Book_isbn) ------------------------------------------------------------------------------------------------------------------------------- Having that a relation can have zero or more foreign keys and each foreign key can refer to different referenced relations. Specify the foreign keys for this schema.

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

  • 4. In Chapter 4, you saw the creation of the Tiny College database design, which reflected...

    4. In Chapter 4, you saw the creation of the Tiny College database design, which reflected such business rules as "a professor may advise many students" and "a professor may chair one department." Modify the design shown in Figure 4.36 to include these business rules: . An employee could be staff, a professor, or an administrator. .A professor may also be an administrator. Staff employees have a work-level classification, such as Level I or Level II. Only professors can chair...

  • I want ER diagram Australian Institute of Music is a music college across the Australia. It provides wide ranges of courses related to music. The top-level management of the college has recently de...

    I want ER diagram Australian Institute of Music is a music college across the Australia. It provides wide ranges of courses related to music. The top-level management of the college has recently decided to computerise the existing paper-based data to a database in order to keep record of all staff, students, courses, etc. Such database will facilitate saving, restoring, and reporting whenever required and reduced paper consumption in the college. The following describes information that is required to save in...

  • Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is...

    Question 1: University Database Consider the following set of requirements for a UNIVERSITY database that is used to keep track of students' transcripts. The university keeps track of each student's name, student number, social security number current address and phone, permanent address and phone, 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 need to refer to the city, state, and zip of the student's permanent address,...

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