Note:

All questions require an ER diagram in proper notation identifying all properties of the relationship.

ER diagrams must be complete in all respects including all cardinality constraints and other specific nature of relationships such as superclass/subclass.

All questions require the specification of tables and associated attributes.

The entire diagram must be in Microsoft Word (including all diagrams) and the final report submitted as a word document.

Also, create the necessary tables in Oracle and submit the SQL statements as part of your word document.

In an apartment complex, a resident can have many pets, but a given pet can have only one resident as its owner. Draw an ER model to represent this relationship. A resident is identified by an apartment number, name, lease begin and lease end dates. A pet has its license number, kind, and its weight.

The course is defined as a section. For example, a course BIS435, can have multiple sections, and each section can have many students, but a student can be enrolled in one only one section. A section is identified by coursed, sectioned, semester, year, and begin and end dates. Draw this relationship between section and students, in an ER diagram. Write the four statements and decide on the number of tables and clearly indicate what the contents of the table would be. Assume that students are defined by student ID. Student Name, Major, and status.

AIRJET is a company that leases out private planes to various company executives. And it has a set of pilots on its list. Each pilot can fly at most ten planes, and a plane can have an unlimited number of pilots eligible to fly. Draw this relationship between planes and pilots. A plane has a model number, the number of hours flown, and the date it was installed in service and the next service date. A pilot has a flying license number, hours flown, and the license expiration date. Decide on the number of tables and include appropriate columns in the respective tables.

AIRTIGHT manufacturing company has full-time and part-time employees. All employees have employee-id, social security number, join date, and department. An employee is either a full-time or a part-time employee. Full-time employees have salary, insurance, and spouse id. Part time employees have hourly pay and contractor id. Draw an appropriate relationship diagram with all markers. Indicate the number of tables and the columns in each table.