Use the ER Diagram shown on Figure 2 to anewer questions 6 and 7: 6. According to the ER diagram on Figure 2, which of the following is true? A) Year Enrolled is a derived attribute. B) STUDENT entity has multiple unique attributes. C) StudEmail is an optional attribute. D) None of the above. Answer: 7. According to the ER diagram on Figure 2, which of the following is true? A) A student must attend a college but can only attend a single college. B) Each college must have multiple students attending it. C) NumOfStudents is a composite attribute. D) None of the above. Answer: StudiD CollD StudName STUDENT Attends COLLEGE ColName StudEmail YearEnrolled (0 NumOIStuder

Use the ER Diagram shown on Figure 2 to anewer questions 6 and 7: 6. According to the ER diagram on Figure 2, which of the following is true? A) Year Enrolled is a derived attribute. B) STUDENT entity has multiple unique attributes. C) StudEmail is an optional attribute. D) None of the above. Answer: 7. According to the ER diagram on Figure 2, which of the following is true? A) A student must attend a college but can only attend a single college. B) Each college must have multiple students attending it. C) NumOfStudents is a composite attribute. D) None of the above. Answer: StudiD CollD StudName STUDENT Attends COLLEGE ColName StudEmail YearEnrolled (0 NumOIStuder

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Question: a) Draw the entity relationship diagram for each of the following Scenario. i) The company has over 100 employees. Each employee is identified by their Employee_ID. Other attributes are Employee_Name, EmployeeAddress, and Skills. An employee may have more than one skill. And each skill can be mastered by many employees or none. ii) A customer can submit orders to buy products. Each order is identified by Order_ID, and Order_Date. A customer may submit any number of orders. Each order is submitted by exactly one customer. The identifier for a customer is Customer_ID. Other attributes include Customer_Name and Customer_Address
The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No of Years represents the number of years the student has engaged in this activity. A given student may engage in more than one activity. Draw an ERD for this situation. What attribute or attributes did you designate as the identifier for the STUDENT entity? Why?
In the attached diagram, which of the following statements are true? primary key for section is course_id, sec_id, semester, year primary key for section is equivalent to the primary key for course unioned with the discrimator section is a weak entity set whose existence depends on course the discrimator of section is sec_id, semester, year
Modify the Er diagram given below and add 5 to 6 more additions to it such as entities attributes relationships etc
Please draw the ER diagram. Explain how you know which one is entity, attribute, and all constraints. Explain each step of the diagram.
Draw an ERD that shows the entities, attributes, primary key(s), foreign key(s), and relationships. Each relationship must be labeled. List all identifying relationships (if any). List all non-identifying relationships (if any). List all independent entities (if any). List all dependent entities (if any). Whenever patients are seen for the first time, they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients signed up to be seen by doctor must be a member of at least one insurance carrier. Each time a patient visits the doctor, an insurance claim is generated and will later be sent to the carrier for payment. The claim must contain information about the visit, such as date, purpose, and cost. It would be possible for a patient to submit two claims on the same day. The relational notation for the database is: Patient (Patient ID, Name, Address, Phone, Primary Carrier,…
Create a rule to extract attributes from one entity type and set them in another.
Entity Relationship Diagram of the business, as shown in the case. Completely and correctly specify all Entities, Relationships and Attributes Order: has one or many items; half by member half by anonymous member (no member number)Has: order number, each order item has total cost (with and without gst), number of store, cashier who took the order, member number (if provided), date on which the order was places, and, if the order is not picked up in-person, the date on which the order is shipped. Order-Item (one of the 1600 products):to identify: useorder number as well as a small “item sequence number” (which is unique within each order). product number, quantity ordered and the actial "unit price paid" If a valid member number is on the order, the system should use the product’s special “member price”, otherwise the product’s “regular price” is used. The average order includes 11 distinct order-items. Member (places 5 orders per month on avg):last name, given names, email…
For each of the following collection of entities, give the assumptions concerning the relationship between entities and attributes. EMPLOYEE(EMP_NUM, EMP_LNAME, EMP_INITIAL, EMP-DOB) DEPENDENT(EMP_NUM, DEP_NUM, DEP_FNAME, DEP_DOB)
use draw a simple diagram of any two entities linked via relationship. On one of the entities, write your university ID.
Use the ER Diagram shown on Figure 1 to answer question 5: 5. According to the ER diagram on Figure 1, which of the following is true? A) Phone is a derived attribute. B) Age is a candidate key. C) Bonus is a multivalued attribute. D) None of the above. Answer: Age EmpID DateOfBirth Email Skill Phone EMPLOYEE YearWithCo Figure 1 LName (FullName) DateOfHire SSN Bonus (0) FName Salary
In the Entity-Relationship (ER) model, list the many types of attributes.