3. Construct Data Dictionary for all tables identified in (1)

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
icon
Related questions
Question
3. Construct Data Dictionary for all tables identified in (1)
Transcribed Image Text:3. Construct Data Dictionary for all tables identified in (1)
Telephone DVD
Number Code
Member
Cost
Name
Tle
Date Out
Date In
Number
(RM)
1012
Inobel Ringer
293847
003
American Ple
2.50
1 Jan 2014
2 Jan 2014
011 My Grandpa in My Pocket
2.00
2 Jan 2014
3 Jan 2014
1034
John Siver
142536
002
Finding Nemo
3.50
17 Feb 2014
18 Feb 2014
015
Shrek
4.00
28 Feb 2014
1 March 2014
1056
Fred Flinstone
817263
003
American Pie
2.50
3 March 2014
4 March 2014
011 My Grandpa in My Pocket
2.00
13 March 2014
14 March 2014
1097
Annette Kirton
384756
008
Frozen
4.00
2 April 2014
3 April 2014
014
Prime Suspect
2.00
3 April 2014
4 April 2014
Transcribed Image Text:Telephone DVD Number Code Member Cost Name Tle Date Out Date In Number (RM) 1012 Inobel Ringer 293847 003 American Ple 2.50 1 Jan 2014 2 Jan 2014 011 My Grandpa in My Pocket 2.00 2 Jan 2014 3 Jan 2014 1034 John Siver 142536 002 Finding Nemo 3.50 17 Feb 2014 18 Feb 2014 015 Shrek 4.00 28 Feb 2014 1 March 2014 1056 Fred Flinstone 817263 003 American Pie 2.50 3 March 2014 4 March 2014 011 My Grandpa in My Pocket 2.00 13 March 2014 14 March 2014 1097 Annette Kirton 384756 008 Frozen 4.00 2 April 2014 3 April 2014 014 Prime Suspect 2.00 3 April 2014 4 April 2014
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Normalization
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.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education