ZuoTi.Pro
Question

Please solve on tables (Please) , for explanation keep it on text only please . the following question :

Q3 : Convert the following ERD to SCHEMA

Presents Teacher name Faculty #Office # Section teaches #Office teching Courses determine CourseName appointment registers Ti

Many thanks in advance.

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

Homework Answers

Answer #1

Solution :

Schema of tables created from above ER diagram :

Faculty :
- #ID
- Teacher_name
- #Office

Course :
- #section
- CourseID
- CourseName

Appointment :
- Day
- Status
- Time
- #Appointment
- #Office

Students :
- StudentID
- Major
- Deanship
- StudentName
- Level

StudentAppointments :(for books relation)
- StudentID
- #Appointment

CourseRegistration : ( for register relation)
- StudentID
- CourseID

CourseAppointment : (for determine relation)
- CourseID
- #Appointment

FacultyCourses : ( for teaches relation)
- FacultyID
- CourseID

FacultyManagesAppointment : (for manages relation)
- FacultyID
- #Appointment

FacultyPresentsAppointment : (for presents relation)
- FacultyID
- #Appointment

Above is the list of all tables and list of attributes in each table. The tables can be further minimized depending on the cardinalities.

if you have any doubts then you can ask in comment section. Thank you.

0 0
Add a comment
Know the answer?
Add Answer to:
Please solve on tables (Please) , for explanation keep it on text only please . the following que...
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

  • Question 2: Provide the tables for the following ERD St-Id D-Id D-name D-LOC S-name Department S-age...

    Question 2: Provide the tables for the following ERD St-Id D-Id D-name D-LOC S-name Department S-age Student C-CRN S-email Takes Course C-name Has C-des F-Id Teaches Offers Faculty F-name Major M-name F-major Teaches F-Office Dependent name Gender age

  • Please write ONE SQL statement for each of the following tasks using the below tables. Note...

    Please write ONE SQL statement for each of the following tasks using the below tables. Note that you can only use conditions specified in the task description and cannot manually look up data and add conditions. Task 1: return title of textbooks with price over $100. Task 2: return number of courses sections scheduled for each year and semester. Please return year, semester, and number of courses. Task 3: Return names of all courses in Information Systems undergraduate program. Task...

  • Create an Entity-Relationship Diagram (ERD). In the ERD include the following:

    Create an Entity-Relationship Diagram (ERD).In the ERD include the following: entities primary keys for all entities attributes - use "good" names for attributes, use only single-valued attributes relationships - use Crow's foot or UML notation; name relationships that could be ambiguous cardinality - minimum (optional/mandatory) and maximum (one or many) on both ends of the relationship - use reasonable assumptions if there is insufficient information in the descriptionStudent/Course registration system for a universityStudents have a unique identification number, first name, middle initial, last name, year...

  • Create sql queries to find the following miscrosoft access compatible commands please 9. Courses for which...

    Create sql queries to find the following miscrosoft access compatible commands please 9. Courses for which at least three students earned a grade of A, showing the grade and the course code 10. Semesters when the highest number of courses have been scheduled, showing the semester name and the number of sections 11. (Extra) Professors that are not students, and students that are not professors, showing their ID and SSN 12. (Extra) Semesters for which all courses are taught by...

  • Problem 1. Please create the following tables for UMBC bookstore’s textbook management system with appropriate primary...

    Problem 1. Please create the following tables for UMBC bookstore’s textbook management system with appropriate primary keys & foreign keys. Please include drop table statements with cascade constraints before your create table statements so it is easier to grade your create table statements. E.g., suppose you will create table tab1, tab2, including the following before creating them: Drop table tab1 cascade constraints; Drop table tab2 cascade constraints; Assumptions: Each teacher can teach one or more scheduled course sections. Each scheduled...

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

  • 2. The following figure shows an ER schema for a university database. a) Map this schema...

    2. The following figure shows an ER schema for a university database. a) Map this schema into a relational schema b)Show the SQL statements needed to create the relations, using proper constraints. If your translation cannot capture any constraints in the ER diagram, explain why. COffice CName CPhone COLLEGE 0. 1 D Rank Office IName IPhone INSTRUCTOR D EAN (0.NO CStartDate (0.1) <ADMINS . CHIAR (1,1) EMPLOYS (MName FName LName (SName DOB DName Sid IO.NO Name Poate DEPT on H...

  • Can someone please help me solve the following database management question a - d please help...

    Can someone please help me solve the following database management question a - d please help uestion-4 The relational database schema of Question-3 is reproduced here. COURSE (NUMBER, TITLE, ENROLLED) RANK-1 (CNUMBER, R1-SSN) RANK-2 (CNUMBER, R2-SSN) TALLEST (CNUMBER, TALL-SSN) STUDENT (SSN, NAME, MAJOR, SEX, GPA) Formulate the following queries in soL. (30] (a) List the course numbers in which "Jack Hernandez" is the first ranked student. You are not allowed to use any JOIN operation and your answer must be...

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

  • Please answer this questions as required I couldn't delete the old pic so the new one is butter and...

    Please answer this questions as required I couldn't delete the old pic so the new one is butter and for the same question. RealGree uses the paper form as below to record the weekly (just one week in this 5. A lawn and tree care company ion) informati application to keep track of the information of the part-time employees. Please (a) develop the E-R diagram (8 points). ion about is part-time employees (one form for one employee). The company asks...

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