Question

Q1. A university registrar’s office maintains data about the following entities:
(a) Courses, including number, title, credits, syllabus, and prerequisites;
(b) Course offerings, including course number, year, semester, section number, instructor(s),
timings, and classroom;
(c) Students, including student-id, name, and program; and
(d) Instructors, including identification number, name, department, and title.
Further, the enrollment of students in courses and grades awarded to students in each course they
are enrolled for must be appropriately modeled.
(i) Construct an E-R diagram for the registrar’s office. Document all assumptions that
you make about the mapping constraints.
(ii) Also convert the ER diagram into a relational database schema. Be certain to indicate
primary keys and referential integrity constraints.

Answer 1

Answer:

Explanation:

Answer:

$\huge \bold \blue{Answer࿐}$

Width of rectangle is 25 cm.

Step-by-step explanation:

Given :-

A wire bend in form of square of side 30 cm.

Then wire is again bend in form of rectangle of length 35 cm.

To find :-

Width of the rectangle.

Solution :-

Here, Concept is : If we are bending wire in form of square than again bending it in rectangle. Than, perimeter of square will equal to perimeter of rectangle because we are not increasing length of wire by one measure we are bending it in square and rectangular shape.

So,

Perimeter of square = 4 × side

⟶ Perimeter = 4 × 30

⟶ Perimeter = 120

Thus,

Perimeter of square is 120 cm.

According to concept, Perimeter of square and perimeter of rectangle are equal.

So, Perimeter of rectangle is 120 cm.

Let, Breadth or width or rectangle be x cm.

We know,

Perimeter of rectangle = 2(Length + Breadth)

⟶ 120 = 2×(35 + x)

⟶ 120 = 70 + 2x

\⟶ 120 - 70 = 2x

⟶ 50 = 2x

⟶ 50/2 = x

⟶ x = 25

We take, Width of rectangle be x.

Therefore,

Width of rectangle is 25 cm.