1. Create an ER model for each of the following descriptions: (a) Each Company operates four Departments, and each Department belongs to one Company. (b) Each Department in part(a) employs one or more Employees, and each Employee works for one Department with a startdate. (c) Each of the Employees in part (b) may or may not have one or more Dependents, and each Dependent belongs to one Employee. (d) suppose: Company with attributes cnumber, cname, caddress, President. Department with attributes dname, dnumber, location. Employee with attributes ename, ssn(for social security number), Sex, address, salary, birthdate. Dependent with attributes dpName, Sex, birthdate, and relationship (to the employee). (e) Represent all the ER diagrams described in (a), (b), (c) and (d) as a single ER diagram. 2. Create an logical data model for relational database of the above designed ER model. Note:1) An logical data model is collection of relational schemas; 2) A relational schema is : tablename(attributename1, attributename2,..., attributenameN). 3. Create a database "Company"; Create each table of the above logical data model into the Company database. 4. Insert at least 3 records into each table of above Company database.

1. Create an ER model for each of the following descriptions: (a) Each Company operates four Departments, and each Department belongs to one Company. (b) Each Department in part(a) employs one or more Employees, and each Employee works for one Department with a startdate. (c) Each of the Employees in part (b) may or may not have one or more Dependents, and each Dependent belongs to one Employee. (d) suppose: Company with attributes cnumber, cname, caddress, President. Department with attributes dname, dnumber, location. Employee with attributes ename, ssn(for social security number), Sex, address, salary, birthdate. Dependent with attributes dpName, Sex, birthdate, and relationship (to the employee). (e) Represent all the ER diagrams described in (a), (b), (c) and (d) as a single ER diagram. 2. Create an logical data model for relational database of the above designed ER model. Note:1) An logical data model is collection of relational schemas; 2) A relational schema is : tablename(attributename1, attributename2,..., attributenameN). 3. Create a database "Company"; Create each table of the above logical data model into the Company database. 4. Insert at least 3 records into each table of above Company database.

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

Q2/II draw the entity relationship for each of the following: 1-" a student studies one or many modules and a module is studied by one or many students". 2-" a manager leads one or many employees and an employee is led by one and only one manager". 3-" a manager leads one or many employees and an employee is led by one and only one manager and if there is a manager who has no employees to lead". 4- "a classroom has one and only one lecturer to manage and a lecturer has one and only one classroom". 5- "each classroom has one or many students registered in and a student has one or many classrooms to be registered in".
Each company operates four departments, and each department belongs to one company. Each department in part (a) employs one or more employees, and each employee works for one department. Each of the employees in part (b) may or may not have one or more dependents and each dependent belongs to one employee. Each employee in part (c) may or may not have an employment history, which includes his employments until the employee joined this enterprise as well as the employment history within the enterprise (after joining). Which of the following statements are true about the ER diagram (assuming it is a good design)? Department will be a weak entity. Employee will be a strong entity. There will be a one-to-many relationship between employee and dependent
Make the entity-relationship model in Luicdchart for the following case: In the company Tecno1818 it is necessary to carry out an inventory of the products that are handled, for this the following information is available. Each product has a code, name, price and a manufacturer code. For the manufacturer you have the code and name
Draw an Entity Relationship Diagram for all of those below. (a simple one) Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for each course there is a unique code and title (not necessarily unique). There might be several lecturers in a course. Each course requires one or more text books. Each text book is used in at least one course. A text book is identified by a unique ISBN, and its title, authors, publisher and year of publication are known. Each course has a unique code. The bank has many customers. Every customer has at least one account with the bank. An account may be shared by several customers. Each customer has a unique number, type, the opening date and the balance. A flight carries many passengers on a specific airplane. Each airplane has a unique number, while each flight has a code (unique), destination and origin. A passenger has a name, passport number and nationality
Create an ER Model for the following requirements: A car has a make, model and year. A registration has a county and date. A person has an address and an age. A car may be owned by a person. A car may be registered to an owner. Explain your reasoning behind 1 choice you made between in the ER diagram in question 1. For example, why choose entity vs relationship, or weak entity vs ternary relationship, or use/disuse of an aggregation, or similar choices.
b. Draw an Entity Relationship diagram from each of the following descriptions. Include the attributes, primary keys (underlines) and the relationships in the diagram (like relationship in Access). i. Each of the department has many employees assigned to it, but each employee works for only one department. if. A customer can rent many videotapes from the video store. Each of the videotapes can be rented to many customers.
Draw an ER diagram to represent the following situation: When appropriate, model an associative entity. B.D. Owen’s Library would like to store information about AUTHORs, BOOKs, book COPYs, and PATRONs. For each AUTHOR, the library stores a unique author ID and the author’s name. For each PATRON, the library will store a unique patron ID, the patron’s name, any phone numbers the patron has, the date the patron joined the library, and the years the patron has been a member, which can be calculated from the date joined. For each BOOK, the library would like to use the ISBN as the identifier. In addition, it would like to store the book’s title, name of the publisher, date of publication, and the number of copies owned by the library. Each book COPY will have a copy number, which uniquely identifies that copy in conjunction with a particular BOOK. The library will also record the condition code of the copy (i.e. excellent, good, fair, poor), last date checked out, and last date returned.…
Draw the associations that are described by the following business rules. Include the multiplicities for each relationship. (4 marks) A patient must be assigned to only one doctor, and a doctor can have one or many patient: An employee has one phone extension, and a unique phone extension is assigned to an employee. A bookstore sells at least one book, and a book can be sold at up to 10 other bookstores around town.
Create a Crow's Foot ERD for the following description: The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be "home" to many of KwikTite's factories. Each factory has many employees, but each employee is employed by only one factory.
PLZ help with the following: Create a Crow’s Foot ERD. Draw YOUR entity relationship diagram (ERD) to indicate entities, relationships, connectives, and resolve M:N relationships. For the following: The faculty and students (we refer to them in our system as clients) can electronically check out any book at any time. A book must have at least one author but can have more authors. An author must have written at least one book or more to be included in the system. A book may have neverbeen checked out, but can be checked out many times by the same client or different clients over time. A client may have never checked out a book or they may have checked out many books over time. To simplify determining which client currently has a given book checked out, a M:N relationship between BOOK and CLIENT should be maintained. The information recorded for each book is book number, book title, book subject, and year of publication. For each author, the library records the author ID,…
draw Entity Relationship Diagram (ERD) for scenairo: “There is a group of employees who have run the website. Three admins are responsible to check registration forms filled by babysitters. An accountant is responsible to check fees payments. All these employees are supervised by the manager. Each babysitter can register on the website one time by filling in her data including first and last names, qualifications, fee rate per hour (25 SAR per Hour), contact information, address, photo, and years of experience. The system will issue for her id and registration date. Mothers can make booking as many as they need. For each time, they must fill in their names, contact information, address, number of children, the date and time (e.g. from 2:00 PM to 4:PM) of booking. The website will generate the booking report including mother’s data, babysitter’s contact data, number of booked hours, fee rate per hour, fees total amount, and tax (%5). To make a payment, the mother needs the…
Question 3 Draw a complete ER diagram using Crow's foot notation based on the given business rules below: A sales representative can write many invoices. (In a business environment, each invoice represents a sales transaction. Given the "commission set" label, one might infer that the sales rep earns a commission on each sale for which an invoice is written) Each invoice is written by a single sales representative. A customer can generate many invoices. (Each time a customer makes a purchase of one or more items, and invoice is generated) Each invoice is generated by a single customer. Each invoice includes one or more invoice lines. (Each item purchased is recorded in an invoice line) Each invoice line is associated with one (and only one) invoice. Each invoice line records a single product. Each product can be recorded in many invoice lines. (If the inventory contains 100 hammers, each one may be sold and, therefore, each of those 100 hammers may at some point be recorded in an…