Question

In: Computer Science

Draw Entity Relation Diagram (ER-Diagram) for this scenario: A faculty has many departments. A department belong...

  1. Draw Entity Relation Diagram (ER-Diagram) for this scenario:

A faculty has many departments. A department belong to one faculty.

Faculty has Faculty ID, Faculty name, Faculty Address

Department has Department ID, Department name

  1. Draw Entity Relation Diagram (ER-Diagram) for this scenario:

Department can have many teachers. Teacher only belongs to one department,

Teacher has teacherID, teacher_name, teacher_address and phone_number

  1. Draw Entity Relation Diagram (ER-Diagram) for this scenario:

Teacher can teach many students. Student can be taught by many teachers.

Student has student_id and student_name

  1. Draw Entity Relation Diagram (ER-Diagram) for this scenario:

Student can register many courses. Courses can be registered by many students

Course has courseID, course_name

  1. Draw Entity Relation Diagram (ER-Diagram) for this scenario:

Department can have many courses. Course belong to one department

  1. Combine all the ER-Diagram from 1 – 5 to be a Complete ER-Diagram for BANK DHOFAR’s website/system with the relationship between Entities.
  2. Draw a line for Primary Key for each Entity in ER-D (Question 6)For Question 6-7

Solutions

Expert Solution

Note:if you get the answer please UPVOTE

Else ,raise your doubt as comment

venereology answered 3 months ago
Next > < Previous

Related Solutions

Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) DRAW ER DIAGRAM AS ONE FULL LIBRARY SYSTEM, NOT DIFFERENT FOR EACH ATTRIBUTE. Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID:...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID: Key identifier, required, simple single valued Book_Name: Key identifier, required, simple, single-valued Genre:...
Every relation in an ER diagram must translate to an individual relation in the resulting relational...
Every relation in an ER diagram must translate to an individual relation in the resulting relational database schema. True/ Flase For any SQL query, there exist a unique translation into relational algebra. True or False IF a relation schema is in 3NF, it is in BCNF. True or false
I need an example of a composite entity replacing a m:n relationship in an Er diagram....
I need an example of a composite entity replacing a m:n relationship in an Er diagram. Need atleast three entities being used.
Draw ATM Scenario and Library Scenario by component diagram and state machine diagram
Draw ATM Scenario and Library Scenario by component diagram and state machine diagram
Draw the diagram (ER / MR / UML) for a database containing the following characteristics: •...
Draw the diagram (ER / MR / UML) for a database containing the following characteristics: • Presence sensor that stores presence information with its timestamp and its location. • Distance sensor that saves distance information with its timestamp and its location. • An actuator of a switch that energizes a bulb, where the record of its been with your timestamp and your location. • An actuator of a motor that opens a door, where the record of its been with...
Draw the ER diagram for the following: Emerging Electric wishes to create a database with the...
Draw the ER diagram for the following: Emerging Electric wishes to create a database with the following entities and attributes: (10) • Customer, with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone • Location, with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential) • Rate, with attributes Rate Class and RatePerKWH After interviews with the owners, you have come up with the following business rules: • Customers can...
Instructions: Draw an ER diagram for the following description. Identify the keys and give the cardinality...
Instructions: Draw an ER diagram for the following description. Identify the keys and give the cardinality of all relationships (e.g. 1:1, N:1, N: M). Make sure you note your assumptions. Assume you are creating a database for a library system with the following properties: The library contains one or several copies of the same book. Every copy of a book has a copy number and is located at a specific location on a shelf. A copy is identified by the...
What role does the entity-relationship (ER) diagram play in the database design process? Discuss the different...
What role does the entity-relationship (ER) diagram play in the database design process? Discuss the different types of information represented in the ER diagram and the symbols used to represent them. How would you approach the diagramming process?
Given the business rule below. Draw the Data directories for each entities & ER Diagram. A...
Given the business rule below. Draw the Data directories for each entities & ER Diagram. A DOCTOR can be scheduled for many APPOINTMENTS, but may not have any scheduled at all. Doctor has the attributes such as DoctorID, Firstname, & Lastname. Appointment has attributes such as AppointmentID, Date & Reason. A PATIENT can schedule one or more appointments. Patient entity has attributes such as PatientID, PatientName & Address. One appointment is scheduled with exactly one patient. An appointment must generate...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT