1. Given the following requirements of a miniworld,
• Each course has a unique course id c_id and a name c_name, is offered by one department, and includes one or more sections. Each course section has a section number sec_no (1, 2, 3, etc.). Sec_no is unique for a given course; but may have duplicated values among different courses. Each section is taught by one instructor and is enrolled by at least 12 students. Each section has the current class size size (derived from students enrolled to the section).
• Each department has a unique id d_id and a unique name d_name, offers one or more courses, and has several phones d_phones. Each department may be majored by or may be minored by some students.
• Each instructor has a unique instructor id i_id and a name i_name, and may teach certain course sections.
• Each student has a unique student id s_id and a name s_name, majors in exactly one department, and may minor in at most two departments. A student may take 0 to at most 5 course sections, each with a grade grade (student-dependent and section-dependent).
a. Use a software tool to draw the “regular” ER diagram (Peter Chen’s style) without using the (min, max) notation. Specify entities, weak entities, attributes, multi-valued attributes, keys (underline), partial keys (dashed underline), relationships (identifying or not, including name, type, participation, cardinality ratio), etc. Any additional attributes (including surrogate key) are not allowed. State clearly any additional assumptions (that cannot conflict with given requirements). Hand-drawing is not allowed. You must embed your name and L3SID into upper center portion in the ERD. Export (not screenshot) the ERD as an image file and insert it as picture into the report file so that ERD picture is viewable in the report. (L3SID is the last 3 digits of your student ID.)
b. Use a software tool to draw the ER diagram (Peter Chen’s style) with the (min, max) notation, corresponding to the “regular” ER diagram in a. Hand-drawing is not allowed. You must embed your name and L3SID into upper center portion in the ERD. Export (not screenshot) the ERD as an image file and insert it as picture into the report file so that
ERD picture is viewable in the report. (L3SID is the last 3 digits of your student ID.)
c. In terms of expressive capabilities of requirements, is there any difference between these two ER diagrams? If so, where and why? Use a specific example to illustrate it.
d. The name of the software tool (Dia, yEd, Draw.io, Lucidchart, Visio, etc.) for a and b.
Submit the following files as individual files (do not zip them together):
• CMPE138_HW1_YourName (.pdf, .doc, or .docx), which includes answers to a, b, c, and d o For a and b, export ERDs from supporting files (with your name and L3SID) as an image file and then insert as picture into CMPE138_HW1_YourName. Do NOT insert ERD screenshot as it is not readable.
o If the actual ERDs in the report are not viewable as pictures or are too blurry to be readable, you will receive 0 point for the entire homework.
• CMPE138_HW1_YourName_Reg_ERD (with proper file extension)
• CMPE138_HW1_YourName_MinMax_ERD (with proper file extension)
1
Two supporting files with the native file format of the software tool, i.e., Dia: .dia, yEd: .graphml, Draw.io: .xml, Lucid Chart: .vdx. Do not submit image files (jpg, bmp, png, etc.) as supporting files.
You must embed your name and L3SID into upper center portion in each ERD. Any submission without supporting files (or without embedding your name and L3SID in ERD) will receive 0 point for the entire homework.

WeCreativez WhatsApp Support
Stuck with your assignment? When is it due? Chat with us.
👋 Hi, how can I help?