Instruction: Create a database design on the following problem. Write your answer on the table provided. Problem A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Steps in Database Design 1. Determine the purpose of your database 2. Find and organize the information required 3. Divide the information into tables 4. Turn information items into columns 5. Specify primary keys 6. Set up the table relationships 7. Refine your design 8. Apply the normalization rules

Instruction: Create a database design on the following problem. Write your answer on the table provided. Problem A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Steps in Database Design 1. Determine the purpose of your database 2. Find and organize the information required 3. Divide the information into tables 4. Turn information items into columns 5. Specify primary keys 6. Set up the table relationships 7. Refine your design 8. Apply the normalization rules

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

Indicate the changes (using the shorthand representation) that you would need to make to the original KimTay Pet Supplies database design to support the following requirements. There is no relationship between customers and sales reps. When a customer places an order, any sales rep can process the order and create the invoice. On the invoice, you need to identify both the customer placing the order and the sales rep responsible for the invoice. Draw an E-R diagram for the new design.
Chapter 7 homework 1. It is easier to organize data and retrieve it when there is little or no dependence between pro- grams and data. Why is there more such depen- dence in a file approach and less in the database approach?2. Spreadsheets have become quite powerful for data management. What can be done with database management systems that cannot be done with spreadsheet applications? Give several examples.3. What is the difference between a database and a database management system?4. DBMSs are usually bundled with powerful pro- gramming language modules. Why?5. DBMSs are a component of every enterprise application, such as a supply chain manage- ment system. Why?6. What are the advantages and disadvantages of object-oriented databases?7. What is the relationship between a Web site’s local search engines and online databases?8. When constructing a database, the designer must know what types of relationships exist between records in different data sets, such as one-to-many or…
May you explain how, as a database designer, you can modify the database's performance for certain use cases? Which one of these options represents the most crucial means through which you may achieve your goal?
Database Lab (CE 450) ( Task 9) B) Objective: Design the Appropriate Database Schema for ER diagram: 1. Identify the tables for the Database. 2. Identify the columns for the tables. 3. Identify the constraints(PRIMARY KEY,UNIQUE,NOT NULL,FOREIGN KEY ) constraints for the columns. An ER diagram for a BANK database schema BRANCHES BANK_BRANCH BANK Code Name Addr Addr Branch_no АСCTS LOANS Acct_no Balance Loan_no Amount ACCOUNT Туре Туре LOAN M A_C LC (Tname Mname Lname Bdate Ssn Name Age Phones CUSTOMER Addr
Design a simple database for a hotel. This hotel may include guests, reservations, rooms, online rates, employees, services, and suppliers. You should draw the E-R diagram and design the relational schema.
The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc., or the words’ PROJECT’, ‘RESTRICT’ etc. as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the dates on which Homer Griffin made purchases. List the first and last names of customers who have bought “Back Scratcher” or “Hair Remover” List the first…
Assume that you are the database developer for this task, complete the information-level design for the new database “Hostipal_Management” that satisfies the constraints and user view requirements given below. User view 1 requirement: The database should have information about Patients, Doctors, Appointments Bills and Payments. User view 2 requirements: Database system will store Patient’s details such as-Patient_ID, name, phone, email and home_address. Patients can make one or more appointments. However, one appointment is scheduled with only one patient. Patients can make several payments to the system, each payment belongs to only one patient. User view 3 requirements: Each doctor has an identification number and his/her name, telephone number, email and speciality should be recorded in the database. Examples for Doctor’s speciality - Cardiologist, Orthopaedics, Oncologists, Urologist, ..etc.(Note: It is a multi-valued attribute). User view 4 requirements: It is required to keep…
You receive the following requirements for a caterer's database: For a customer, store a customer ID, last name, first name, billing address, and phone number For an order, store an order number, order date, event date, customer ID, description of services, and total price for services When designing this database, which step do you take first? a. Identify the customer ID and order number as unique identifiers. b. Identify and name the entities CUSTOMER and ORDER c. Identify customer ID, last name, first name, billing address, and phone number as attributes d. Create a CUSTOMER table that includes all the customers' attributes as columns
Explain what it means to repeat information and not be able to represent information. Explain why each of these things could be signs of a bad relational database design.
1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.) 2. Design a database diagram for a database that stores information about the downloads that users make from a website. Each user must have an email address, first name, and last name. Each user can have one or more downloads. Each download must have a filename and download date/time. Each product can be related to one or more downloads. Each product must have a name.
T. Relational Model Instructions This assignment will show that you understand how columns should be separated between tables in a properly structured relational database. Your objective: Imagine you need to design a database that tracks members, type of membership, and exercise routines for each member. • Build a relational database model with multiple tables • Use your imagination and feel free to create the tables with as many columns as you would like. • Highest points will be awarded for completeness AND correctness. Submit as an Excel workbook or image.
Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…