This is a simple list table of a company trying to keep track of employee assignment to company protects (In other words, not a database but a flat one table file). You will design a database for this company so that they won't be retying on a simple I table list system to keep track of their data Looking at the table below, produce the 3Nf of the data Normalize to the first three normal forms Project Code Project Project Employee Employee Department Department Hourly Project Manager Budget Name Name Reservation Mr. Ajay System Reservation Mr. Ajay System Reservation Mr. Ajay System HR System HR System HR System Attendance Mr. Rajesh 710700 S137 No. Name No. Rate PC010 120500 S100 Mohan D03 Database 21.00 PC010 120500 S101 Vipul D02 Testing 16.50 PC010 120500 S102 Riyaz D01 IT 22.00 PC011 Mrs. Charu 500500 s103 Pavan D03 Database Testing 18.50 PC011 Mrs. Charu 500500 s104 Jitendra D02 Pooja 17.00 23.50 PC011 Mrs. Charu 500500 S315 D01 IT PC012 Rahul D03 Database 21.50 System Attendance PC012 Mr. Rajesh 710700 S218 Avneesh D02 Testing 15.50 System Attendance PC012 Mr. Rajesh 710700 S109 Vikas D01 IT 20.50 System

This is a simple list table of a company trying to keep track of employee assignment to company protects (In other words, not a database but a flat one table file). You will design a database for this company so that they won't be retying on a simple I table list system to keep track of their data Looking at the table below, produce the 3Nf of the data Normalize to the first three normal forms Project Code Project Project Employee Employee Department Department Hourly Project Manager Budget Name Name Reservation Mr. Ajay System Reservation Mr. Ajay System Reservation Mr. Ajay System HR System HR System HR System Attendance Mr. Rajesh 710700 S137 No. Name No. Rate PC010 120500 S100 Mohan D03 Database 21.00 PC010 120500 S101 Vipul D02 Testing 16.50 PC010 120500 S102 Riyaz D01 IT 22.00 PC011 Mrs. Charu 500500 s103 Pavan D03 Database Testing 18.50 PC011 Mrs. Charu 500500 s104 Jitendra D02 Pooja 17.00 23.50 PC011 Mrs. Charu 500500 S315 D01 IT PC012 Rahul D03 Database 21.50 System Attendance PC012 Mr. Rajesh 710700 S218 Avneesh D02 Testing 15.50 System Attendance PC012 Mr. Rajesh 710700 S109 Vikas D01 IT 20.50 System

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

Related questions

Q: StayWell also rents out properties on a weekly basis to students attending summer school in the…

A: In the given question we have to write the database schema for three cases using abbreviated…

Q: Syntax for drop table cascade constraints drop table with restrict syntax for On delete/update…

A: A SQL query can be defined in such a way that it is a command that is basically used to interact…

Q: You are to design a Hospital database. So before creating the database, your task is to design the…

A: This is very simple. An ER diagram, called an entity-relationship model, describes the interest in a…

Q: There are two basic ways to design a well-structured relational database. The method in which a…

A: A database system as the management system as the file of the processing as the based service of the…

Q: rite the SQL statements to create all of the necessary tables to represent the above diagram,…

A: Note: Since you have not provided the database name to write the SQL query so I am using the MYSQL…

Q: What is the primary key of the WorkHours table? Indicate the redundant field in the Employees table.

A: This question comes from Database Management System which is a paper of Computer Science. Let's…

Q: as a database you need to ensure that each excercise log has a unique ID number, date, excercise…

A: The question has been solved in step2

Q: Choose a database application with which you are familiar. Design a schema and show a sample…

A: Design a schema and show a sample database for that application, using the notation of Figure 1.…

Q: Seminar eminar ID Integer eminar Date Date Seminar Time Time ocation Seminar Title Address String…

A: As the customer may or may not attend the seminar or several seminars, the seminar and the customer…

Q: What data types would you use for the attributes in this entity? How would you code a CREATE TABLE…

A: In a database management system (DBMS), an attribute is a piece of data that describes an entity.…

Q: Assume that you are an employee of a consultancy company that specializes in the analysis, design,…

A: Executive summary: This report aims to provide an overview of the fact finding techniques that will…

Q: A database programmer's concentration on information is what sets them apart from other programmers.…

A: Database administrators and programmers alike create, maintain, and update databases. They are…

Q: Convert the below E/R diagram to relational database scheme form. Date Number Quantity Payment_info…

A: The Relational scheme is given below:

Q: The following four tables form part of a library database: • Book (isbn, title, author, genre,…

A: A library database is a structured collection of information designed to manage and organize…

Q: Task 4: As a part of marketing strategy, the Marketing team continuously conducting an advertising…

A: Actually, database is a used to stores the data.

Q: An E-learning website needs your help to design its database. They need to store information about…

A: Answer is given below .

Q: CUSTOMER Ữ CustomerID FirstName LastName Phone EmailAddress INVOICE InvoiceNumber Customer D Dateln…

A: Schema Structure- --------------Customer---------------- CustomerID (Primary Key)- FisrtName-…

Concept explainers

Types of database architectures

A Database Architecture represents the Database Management System’s (DBMS) design (schema). The DBMS architecture makes it easy to understand the components involved in the database system and their relations. The DBMS architecture may vary based on the system on which it runs. Some systems contain both client and server machines whereas some run only on a server machine. Based on the architecture, the system can be classified as centralized, decentralized, or hierarchical.

Question

This is a simple list table of a company trying to keep track of employee assignment to company
protects (In other words, not a database but a flat one table file). You will design a database for this
company so that they won't be retying on a simple I table list system to keep track of their data
Looking at the table below, produce the 3Nf of the data
Normalize to the first three normal forms
Project
Project
Project
Project Employee Employee Department Department Hourly
Manager Budget
Name
Reservation Mr. Ajay
System
Reservation Mr. Ajay
System
Reservation Mr. Ajay
System
HR System
HR System
HR System
Code
Budget
No.
120500 S100
Name
No.
Name
Rate
PC010
Mohan
D03
Database
21.00
PC010
120500 S101
Vipul
D02
Testing
16.50
PC010
120500 S102
Riyaz
D01
IT
22.00
500500 S103
500500 S104
500500 S315
710700 S137
PC011
Mrs. Charu
Pavan
D03
Database
18.50
Jitendra
Pooja
PC011
Mrs. Charu
D02
Testing
17.00
PC011
Mrs. Charu
D01
IT
23.50
PC012
Attendance
Mr. Rajesh
Rahul
D03
Database
21.50
System
Attendance
PC012
Mr. Rajesh
710700 S218
Avneesh
D02
Testing
15.50
System
Attendance Mr. Rajesh
PC012
710700 S109
Vikas
D01
IT
20.50
System

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Q1:Draw ERD for the following database (Library) Customer Card number Password Name | Address ID Phone Username number Employee ID Phone number Password Username Name Branch number Card Number CW Branch Number Address | Phone number Bill Customer id Employee id Total price Order ID Day Time Book Isbh Name Availability Id Cost Address Cart Order number Book id Customer id Card number Customer Total price name
Topic: Database Design What are some concerns about using a date (or date time) as a primary key?
Please refer to the following diagram for Q19 to Q20. PERSON PK P_ID P_LNAME P_FNAME ΕMPLOYΕ P_ID EMP_HIRE_DATE STUDENT P ID STUDY ΜAIOR PK, FK1 PK, FK1 19. Which of the following statements is/are true? (1) A Person must be either a Student or an Employee. (2) A Person can neither be a Student nor an Employee. (3) A Person must be a Student or an Employee or both. a. (1) only b. (3) only c. (1) and (2) only d. (1), (2) and (3).
Part A - Database design case study In this part, you need to provide a short description of the application/website for which you will be designing the database (The overview of your own/chosen case study that is related to the assignment topic), outline the basic functions that your database needs to support, identify the data requirements, and business rules.
Show the list of courses (all attributes) that are provided by the computer science department in the ascending order of course number.
Design your application's/organization's database. You need to create the 3 tables for each of the services offered. You must provide at least 5 examples in each of the table. There must be a table in which you have prices linked to the services you are providing. THIS IS THE NAME & DESCRIPTION OF THE ORGANIZATION FOR WHICH YOU NEED TO CREATE 3 TABLES FOR EACH SERVICE PROVIDED *Name of the Organization* :: ECOHUB *Description of the Organization* :: EcoHub is a sustainability-focused organisation that seeks to encourage environmentally friendly behaviours, increase public knowledge of environmental problems, and offer solutions for people, organisations, and communities to reduce their carbon footprint and help make the world a greener place. We think that many little individual actions can have a big influence on the environment when taken together. *Services Offered by the Organization are*1. EcoConsultancy : We provide individualised eco-consultancy services to people and…
StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have several reservations for upcoming visits. Table: Camper CAMPER_NUMBER 1000 1001 1002 1003 CAMPER_LAST_NAME Jones Schmidt Williams Cooper CAMPER_FIRST_NAME Jamie Pat Clifford Amanda CAMPER_ADDRESS 1278 Essex Pl 4954 Spangled Way 956 Segull Lane P. O. Box 998877 CAMPER_CITY Birmingham El Paso Portland Portsmouth CAMPER_STATE AL TX ME OH CAMPER_ZIP_CODE 45251 79919 4108 45662 CAMPER_DRIVERS_LICENSE JJ998743-98 87632434 WIL885123 765A876B897 CAMPER_EMAIL jjones@somewhere.com patwonderfu34l@nowhere.net williams98342@foomail.com coopera@nowhere.net Table: Spot SPOT_NUMBER 101 102 103 104 SPOT_NAME The Pines The Glade Teardrop Spot Tent In Trees…
Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort the name by ascending order.
Customer Equipment Loan id equipmentCode name id name H description RentalRatePerDay address 04 equipment Code e contact startDate dateOfBirth returnDate occupation DamageReport reportId damageType (iii) Create a view named CustomerSummary with details of each customer, the number of equipment rented, the total amount of rental collected thus far and the number of damages caused by customer and not due to wear and tear. ID Name Address Contact DateOfBirth Occupation Number of Equipment Rented Total Rent NumDamage ST82J Charles Toles 23 Haig Road 92142331 15-03-1976 Teacher 20.00 S823F Damien Low 5 Still Road 88128833 05-07-1985 Teacher 1 16.00 1 3 sa56F Audrey Ng 10 Bedok Road 82138213 23-01-1988 Nurse 3 150.00 1 2 Jalan Eunos 8 Jalan Melayu Ali Bin Mohd Hassan 10 Clomonti Road 91239123 4 S345G Betsey Tan 98981212 12-05-1990 Cartoonist 4.00 99234J Peter Lee 97589758 04-03-1991 Student 1 24.00 SATSZ S575J Ravi S/O Ramasamy 12 Jurong Road 6 10-07-1997 IT Programmer 0.00 7 82223333…
Consider the following schema for a company database and answer the following questions: DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date M EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Dno M WORKS ON Esan Pno Hours PROJECT Pname Pnumber Plocation Q1//create all tables of this schema and apply any necessary constraints
John liked your work so much that he would like you to create a database for the comic book shop that you worked with in the first project. Create a relational database with at least two tables. Comic book and company would be two logical ones