We need to create a database ER design based on the following (simplified) requirements of the COMPANY Database: The company is organized into DEPARTMENTS. Each department has a name, number, and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. Each department controls a number of PROJECTS. Each project has a unique name, unique number, and a brief description. We store each EMPLOYEE's social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee currently works on each project. We also keep track of the direct supervisor of each employee. Each employee may have a number of DEPENDENTS. For each dependent, we keep track of their name, sex, birthdate, and relationship to the employee. We assume each dependent only has one parent who works for the company.

We need to create a database ER design based on the following (simplified) requirements of the COMPANY Database: The company is organized into DEPARTMENTS. Each department has a name, number, and an employee who manages the department. We keep track of the start date of the department manager. A department may have several locations. Each department controls a number of PROJECTS. Each project has a unique name, unique number, and a brief description. We store each EMPLOYEE's social security number, address, salary, sex, and birthdate. Each employee works for one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee currently works on each project. We also keep track of the direct supervisor of each employee. Each employee may have a number of DEPENDENTS. For each dependent, we keep track of their name, sex, birthdate, and relationship to the employee. We assume each dependent only has one parent who works for the company.

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

You are to design a Hospital database. So before creating the database, your task is to draw the ER diagram based on the following data collected and analyzed: A hospital will have a name, unique id, multiple helpline numbers (one for doctor's appointment, one for ambulance, one for bill information and one for other services' info) and locations. A hospital may have more than one location as it may have different branches and each of the locations will have a building no., street address, road no. and city name. A patient will have a name, unique ID, may have more than one phone number, age, height, weight and symptoms. A patient takes an appointment in a hospital and the appointment date is recorded. A patient may have an attendant. An attendant will have his/her name, contact numbers and relationship with the patient as a record in the database. Due to the covid situation, the hospital authorities will only allow 1 attendant with 1 patient.
Your job as a database designer is to design a database with a schema that captures all the information that galleries need to maintain. Galleries keep information about artists, their names (which are unique), birthplaces, age, and style of art. For each piece of artwork, the artist, the year it was made, its unique title, its type of art (e.g., painting, photograph, sculpture), and its price must be stored. Pieces of artwork also classified into groups of various kinds, for example, portraits, still lives, works by Picasso, or works of the 19th century; a given piece may belong to more than one group. Each group is identified by a name (like those just given) that describes the group and property. Finally, galleries keep information about customers. For each customer, galleries keep that person’s unique ID, name, address, total amount of dollars spent in the gallery, and the artists and groups of art that the customer tends to like. Draw the ER diagram for the database.
You are to design a Hospital database. So before creating the database, your task is to design the ER diagram based on the following data requirements: The hospital has departments. Each department has a name, department ID, location. Location consists of floor number and wing number (which will contain the values North, South, East or West). b. Doctors work for the department. Doctors have license number., name, title, multiple specializations. Some doctors supervise other doctors. c. A patient will have a name, unique ID. may have more than one phone number, age, height, weight and symptoms. d. Patients take appointments from doctors. Appointment date and time is recorded. e. A patient may have an attendant. An attendant will have his/her name and relationship with the patient as a record in the database. The hospital allows 1 attendant with each patient. Write down any assumptions you may have made.
We would like to design a database to store information that is related to a charity agency, the database requirements are as follows: Information kept about each employee: Employee identification number (unique for each employee), username and password, name for each employee, date of birth, phone, and email. Information kept for each Donation: Donation identification number (unique for each donation), donation date, and donation type. Information kept for each donor: Donor identification number (unique for each donor), the donor name, the donor name stored separately (first name, second name, and last name), the donor address also stored separately (street number, street name, zip code, city), the phone, and the email. Information kept about each item donated: Item identification number (unique for each item), item name, and quantity. Information kept for each needed/supported family: Family name, number of members in the family, nationality, address, income, and phone…
Do database designers need to be aware of any specific technique that, when used in certain situations, has the potential to have a significant impact on a database's performance?
Tropic Vibe Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer. • Each musician that records at Tropic Vibe has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone. • Each instrument used in songs recorded at Tropic Vibe has a unique identification number, a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, Bflat, E-flat). • Each album recorded on the Tropic Vibe label has a unique identification number, a title, a copyright date, a format (e.g., CD or MC), and an album identifier. • Each song recorded at Tropic Vibe has a title and an author. • Each musician may play several instruments, and a given instrument may be played by several musicians. • Each album has a number of songs on it, but no song may appear on more…
FeastFam is a restaurant group which consists of multiple restaurants nationwide. Due to recent restrictions imposed by the government, the group has had to adapt to a new way of managing information in their daily operations. FeastFam has approached you to help them with the creation of a database which will keep track of the following information: • FeastFam franchise group has a main headquarter office. The address of this office should be stored in the database. • FeastFam has many restaurants across South Africa (indicated using a “has-a" relationship). • Each restaurant has a name, location and phone number. To handle reservations the following needs to be considered: • Each restaurant can have many customers make reservations. • Each customer can have many restaurants at which they make reservations. • Each customer has a name, surname and contact number. • For each reservation the following information is stored: Date, time, number of guests. When the customer arrives with…
We would like to design a database to store information that is related to a charity agency, the database requirements are as follows: • Information kept about each employee: o Employee identification number (unique for each employee), username and password, name for each employee, date of birth, phone, and email. • Information kept for each Donation: o Donation identification number (unique for each donation), donation date, and donation type. • Information kept for each donor: o Donor identification number (unique for each donor), the donor name, the donor name stored separately (first name, second name, and last name), the donor address also stored separately (street number, street name, zip code, city), the phone, and the email. • Information kept about each item donated: o Item identification number (unique for each item), item name, and quantity. • Information kept for each needed/supported family: o Family name, number of members in the family, nationality, address, income, and…
Database Foundations: Design a database to produce the following reports. Do not use any surrogate keys in your design. For each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired. For each trip, list the trip ID number, the trip name, the location from which the trip starts, the state in which the trip originates, the trip distance, the maximum group size, the type of trip (hiking, biking, or paddling), the season in which the trip occurs, and the guide number, first name, and last name of each guide. A guide may lead many trips and a trip may be led by many different guides. For each client, list the client number, client last name, client first name, address, city, state, postal code, and telephone number
The most significant technique that database designers may utilize to influence database performance in particular usage scenarios is what you can find out here.
Please help 1 Problem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1– 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track ofsimilar information for suppliers as well (although instead of supplier first and last name, there will just be a suppliercompany name). The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought). 1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more…
Database normalization is a very important process in designing and organizing tables (relations) and their columns (attributes or fields) in a relational database. Therefore, what are the consequences (problems) if a database was designed without it? Would the database still work?