The below data is in first normal form. Normalise the data to third normal form, howing all steps with explanations. Dependency diagrams or tabular data are acceptable for the final answer. Primary key: PlayerName, CharacterName Player Player Character Character Character Name DateJoined Name Level Мax Health Bob 2014-12-31 George 50 800 Bob 2014-12-31 Fred 50 1200 Alice 2015-05-09 ZeAlice 21 350 Charles 2016-09-09 HisRoyalHighness 30 470 Delta 2020-02-29 WarriorDelta 50 1205 Delta 2020-02-29 DeltaMage 2 60

The below data is in first normal form. Normalise the data to third normal form, howing all steps with explanations. Dependency diagrams or tabular data are acceptable for the final answer. Primary key: PlayerName, CharacterName Player Player Character Character Character Name DateJoined Name Level Мax Health Bob 2014-12-31 George 50 800 Bob 2014-12-31 Fred 50 1200 Alice 2015-05-09 ZeAlice 21 350 Charles 2016-09-09 HisRoyalHighness 30 470 Delta 2020-02-29 WarriorDelta 50 1205 Delta 2020-02-29 DeltaMage 2 60

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

The table STUDENT has the attributes STUDENT_ID, NAME, SCHOOL_ID, and ADDR. The table SCHOOL has the attributes SCHOOL_ID, NAME, and STATE_CODE. Assume that there is a 1:N relation between SCHOOL and STUDENT. Which of the following creates a table that shows the STUDENT attributes and the corresponding SCHOOL attributes? a. SELECT * SCHOOL_ID FROM STUDENT JOIN SCHOOL b. SELECT * SCHOOL_ID FROM STUDENT JOIN SCHOOL USING(SCHOOL_ID) c. SELECT * SCHOOL_ID FROM STUDENT NATURAL JOIN SCHOOL d. SELECT * SCHOOL_ID FROM STUDENT, SCHOOL WHERE SCHOOL_ID = SCHOOL_ID
Using the Henry Books database, increase the price of book “The Fall” by 10%. You will insert 2 snips for this question.
the charts are to be in sql. Need some help around the primary keys and foreign keys CREATE TABLE Countries ( PRIMARY KEY() CountryID int, CountryName varchar(100), Leader varchar(100), Population int, WarSide varchar(10) MilitaryStrength int, CasualitiesLost int, WarOutcome varchar(30) ); --the two sides to the war CREATE TABLE Allies ( CountryID CountryName WarSide TotalStrength BattlesWon BattlesInvolved WarResult TotalCasualties int, ); CREATE TABLE Central ( CountryID int, CountryName WarSide TotalStrength BattlesWon BattlesInvolved WarResult TotalCasualties int, ); --many to many for countries and battles CREATE TABLE CountyBattles ( id int NOT NULL, CountryID int, BattleID int, PRIMARY KEY (id), CONSTRAINT fk1 FOREIGN KEY (CountryID) REFERENCES Countries(CountryID), CONSTRAINT fk2 FOREIGN KEY (BattleID) REFERENCES Battles(BattleID) ); CREATE…
Task 1: ' The Car Maintenance team wanted to ensure that the default price of the maintenance actions should not be empty and 0 instead if not specified. Alter the MAINTENANCE_TYPES table created in Chapter 8, Activity 1 to set the default MAINTENANCE_PRICE to 0. ANSWER IN MYSQL PLEASE
Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT. ANSWER IN MYSQL PLEASE
Q7: An ERD about a company has been mapped to the following Relations. Please choose the correct statement that describes the company Employee(ID,E.Name, Salary) Project(Name, Location, ID) Project Location(Name, Location) a. A company has several projects and employees. An employee can work on one or more projects. A project can be located at several locations b. A company has several projects and employees. An employee can work on a single project only and each project has several employees. A project can be located at several locations c. A company has several projects and employees. An employee can work on one or more projects. A project is located at a single location d. A company has several projects and employees. An employee can work on one project only. A project can be located at several locations Employee EID 001 002 003 004 005 006 Name Ahmad Ali Sameh Salem Huda Ali Department group by Name order by EID; a. TWO columns and FOUR records b. TWO columns and ONE record c. TWO…
Can you explain what it means to be transitive? What is the rule for converting tables from the second normal form to the third normal form?
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.
Assume a candidate key is a main key attribute. Your response?
Query design by referring the following scenario.Scenariocompany has a huge database to handle their employees’ details.Most of the details regarding the employee activities and department details are stored in Employeestable and Departments table. Write the appropriate query to support the manager to complete thefollowing:
For the following Student table, find all the possible functional dependencies that arehe ld.Schema: Student (Regno, Name, DOB, Phone, Instructor_ID, Instructor_Name, Instructor_Office)Gender, Course_ID, Course_Na me ,Regno Name 14M01 Kumar 14M05 Mary 14M07 Ram 14M01 Kumar 14B01 Revathi 14M09 Steve 14B03 RamyaDOB 12-Jan-1996 10-Jun-1995 10-May-1996 12-Jan-1996 10-Dec-1995 23-Oct-1995 20-Jul-1996Phone 12345 12367 12898 12345 23456 34567 23456Gender CID M C1 F C1 M C1 M C3 F C3 M C4 F C4CNam