1. Please draw and submit an ERD that satisfies the following description • 3 entities: a. Apartment building: (id, address, name) b. Apartment (apartment number, number_of_bedrooms, number_of_bathrooms) [weak entity] c. Tenant (person_name) • 2 relationships a. Contained_in: Identifying relationship between apartment and apartment building. Each apartment building must have at least one apartment and can have many. Each apartment must be in one and only apartment building b. Leased: relationship between tenant and apartment. Has the following attribute; Date_rented. Each apartment can be rented by many tenants. Each tenant can have many apartments. Make sure you do the minimum cardinalities too (make them reasonable and explain them to me in text).

1. Please draw and submit an ERD that satisfies the following description • 3 entities: a. Apartment building: (id, address, name) b. Apartment (apartment number, number_of_bedrooms, number_of_bathrooms) [weak entity] c. Tenant (person_name) • 2 relationships a. Contained_in: Identifying relationship between apartment and apartment building. Each apartment building must have at least one apartment and can have many. Each apartment must be in one and only apartment building b. Leased: relationship between tenant and apartment. Has the following attribute; Date_rented. Each apartment can be rented by many tenants. Each tenant can have many apartments. Make sure you do the minimum cardinalities too (make them reasonable and explain them to me in text).

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 5MC

See similar textbooks

Similar questions

Which of the following symbols represents an optional relationship in an E-R model? a. a straight line b. a dashed line c. a straight line with a crows foot at both ends d. a straight line with a crows foot at one end
Redo the Music store ERD from the previous lab assignment. This time, create a supertype of product and have four subtypes for product. These subtypes should be sheet music, instruments for sale, supplies, and lessons. Determine what fields these items all share in the supertype and then provide at least three attributes for each subtype that are particular to that type of product.
Question=1)DRAW : Matrix diagram of this entities project will be about a student attendance. Entities: student, course, instructor, attendance, enrollment, department, class. Relationships: Student is enrolled in course, Course has instructor, Department has many courses, Entities: 1. Student - Attributes: Student_ID (Primary Key), Name, Age, Email, Phone _Number 2. Course - Attributes: Course_ID (Primary Key), Course_Name, Department_ID (Foreign Key) 3. Instructor - Attributes: Instructor_ID (Primary Key), Name, Department_ID (Foreign Key) 4. Attendance - Attributes: Attendance _ID (Primary Key), Student_ID (Foreign Key), Course_ID (Foreign Key), Date, Status 5. Enrollment - Attributes: Enrollment_ID (Primary Key), Student_ID (Foreign Key), Course_ID (Foreign Key), Enrollment Date 6. Department - Attributes: Department_ID (Primary Key), Department_Name 7. Class - Attributes: Class_ID (Primary Key), Class_Name, Department_ID (Foreign Key) Draw Matrix diagram of this scaniorio
Create a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager…
Identify the main key attribute, composite attribute, simple attribute, multivalued attribute, and derived attributes for each object. Assign appropriate labels to characteristics.
Creating a database Diagram. Does the attached image meet these criteria? Week 6: Lab Instructions Now lets consider designing a database for the a car lot. Consider the following statements -> Our car lot sells many cars every month (we have a big inventory) Our car lot has many customers (everyone loves us!) Our car lot has many sales persons (we are ready to help our customers) Each car sale persons sells many cars a week (our prices are great) Our car lot provides many mechanical services (all our mechanics are experts) Our Service department has many mechanics (any mechanic would love to work here) Our mechanics provide service to our customers (our repeat business is awesome) Examine the above information and determine the Entities. With each entity - determine some attributes for each entity. As a note - is there any information in the above statements that is not helpful for our database design? Now lets consider our Car Lot database design and determine the…
Discuss briefly the permissible transformations for the different attribute types.?
Which of the following symbols represents a many-to-many relationship in an E-R model?a. a straight lineb. a dashed linec. a straight line with a crow’s foot at both endsd. a straight line with a crow’s foot at one end
Add the data type of each attribute. Establish, justify and describe the Methodology with which the project will be developed. Determine Patient Details Entity: Patient Description: Individuals seeking medical attention or medicines. Attributes: RUT (Primary Key): Unique identification number for each patient. Name: First name of the patient. Surname: Last name of the patient. Date of Birth: When the patient was born. Email: Digital contact detail. Address: Residential information. Telephone Numbers: Multiple contact numbers. Pension System: Type of retirement financial support. Classify Health Forecasts Entity: Health Forecast Description: Diverse types of health coverage systems. Attributes: Code (Primary Key): Distinct code to identify health forecasts. Type: Nature of the health forecast, either social or private. Profile Physicians Entity: Physician Description: Medical professionals responsible for patient care. Attributes: RUT (Primary Key): Unique identifier…
For each object, determine the primary key attribute, the composite attribute, the simple attribute, the multivalued attribute, and the derived attributes. Give characteristics the proper names.
Please help asap. Thank you in advance In a company called BCCD engineers are charged of developing different types of applications. Each engineer is identified by an Employee ID, First Name, Last Name, address, phone and E-mail (Please note that the company is only keeping data for one phone, and one e-mail - Thus, you do not have to worry about multivalued attribute). Each application is identified by an application ID, Name and type. Each engineer must work on one or many applications. Applications must be developed by one or more engineers. The company wants to keep track of the date each of the engineers started working on the assigned application. Each engineer is allocated one personal computer. Each PC can only be used by one engineer. A couple of newly hired engineers have yet to get a PC. A PC is identified by a Serial Number, Make, and Model. 1- Some engineers were promoted to a supervisory position. Those promoted engineers supervise one or many other engineers. Each…
For each object, determine the main key attribute, composite attribute, simple attribute, multivalued attribute, and derived attributes. Assign the proper labels to the traits.