Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SQL IT Trouble Ticket Table: description location date Requested dateCompleted techName Fix printer TC 116 2015-03-09 2015-03-10 B.Rubble Reformat hard drive on machine 10 TC

image text in transcribed

image text in transcribed

SQL IT Trouble Ticket Table: description location date Requested dateCompleted techName Fix printer TC 116 2015-03-09 2015-03-10 B.Rubble Reformat hard drive on machine 10 TC 116 2015-02-20 2015-02-22 W. Flintstone Upgrade memory on machine 12 JTC 116 2015-03-01 2015-03-09 B. Rubble |Reinstall Java SDK on machine 12 TC 118 2015-03-09 W.Flintstone Upgrade VMWare TC 118 2015-03-09 Question#1 Using the IT Trouble Ticket Table shown above Identify and describe at least three of the following issues: a. Any problems with unnecessarily repeated (i.e. redundant) data. b. Any problems with atomicity -that is columns that store more than one piece of information. For example: multiple dates, multiple names, or multiple pieces of address information. C. Any NULL values (if any). d. Any groupings of columns that really belong in separate tables because they really describe different entities. NOTE: having a day, month, and year in a single column is not a problem (it is still atomic for practical purposes). Question#2 Try to separate out all of the information stored in the above IT Trouble Ticket Table into outlines for four new tables called: Task, Location, Appointment, and Technician. For each new table include only columns from the IT Trouble Ticket Table that really belong to that new table. For example, the new Task table should only contain columns from the IT Trouble Ticket Table that describe Task specific attributes (e.g. Description). Do not be concerned if there does not seem to be too many columns from the original IT Trouble Ticket Table that pertain to each new table. In your listing of the new tables you do not have to list all the data inside the rows of the IT Trouble Ticket Table only the column headings. Please make sure all the columns in your new tables are split up properly so they are atomic (i.e. store only one piece of information). NOTE: it is ok to rename or split up columns from the original IT Trouble Ticket Table but you cannot just throw away any of the original columns from the IT Trouble Ticket Table! Sample New Table Listings: Task(Description, etc...) Location (etc....) Appointment etc...) Technician(etc...) NOTE: The etc... here denotes the rest of the properly associated, atomic columns that should be grouped under their correct table. You should not have the same column in more than one table! Question#3 Identify a unique lookup on each table (it is ok to make up a new column)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions

Question

What is meant by planning or define planning?

Answered: 1 week ago

Question

Define span of management or define span of control ?

Answered: 1 week ago

Question

What is meant by formal organisation ?

Answered: 1 week ago

Question

What is meant by staff authority ?

Answered: 1 week ago