Data Dictionary - how to answer the following questions for each table: p lease
ID: 3843938 • Letter: D
Question
Data Dictionary - how to answer the following questions for each table: please provide a second sentence describing the table describing the PK. Please provide a third table describing tables it has a connection to and any FKs.
BOOKS: Table to track books. Please provide a second sentence describing the table describing the PK. Please provide a third table describing tables it has a connection to and any FKs.
Field Name
Description
Data Type
Constraint
PK/FK
ISBN_NO
ISBN
Varchar(20)
Not null
PK
AUTHOR
Authors name
Varchar(50)
Not null
CATEGORY
Type of book
Varchar(100)
Not null
PUB_NO
Publication Number
Int(10)
Not null
FK
PUBLISHER: Table to track publishers. Please provide a second sentence describing the table describing the PK. Please provide a third table describing tables it has a connection to and any FKs.
Field Name
Description
Data Type
Constraint
PK/FK
PUB_NO
Publication Number
Int(10)
Not null
PK
NAME
Publisher Name
Varchar(50)
Not null
STREET_ADDRESS
Publisher Info
varchar(50)
Not null
CITY
Publisher Info
varchar(50)
Not null
STATE
Publisher Info
char(2)
Not null
ZIPCODE
Publisher Info
char(5)
Not null
CONTACT
Contact number
Varchar(10)
Not null
PUB_DATE
Date published
Date(YYYY-MM- DD)
Not null
NEWSPAPER: Table to track newspapers. Please provide a second sentence describing the table describing the PK. Please provide a third table describing tables it has a connection to and any FKs.
Field Name
Description
Data Type
Constraint
PK/FK
NEWS_ID
News ID
Varchar(20)
Not null
PK
DATE
Data published
Date(YYYY-MM- DD)
Not null
LEAD_ARTICLE
Article Title
Varchar(100)
Not null
MAGAZINES: Table to track magazines. Please provide a second sentence describing the table describing the PK. Please provide a third table describing tables it has a connection to and any FKs.
Field Name
Description
Data Type
Constraint
PK/FK
MAG_ID
Mag ID
Varchar(20)
Not null
PK
NAME
Magazine name
Varchar(50)
Not null
VOLUME
Volume
Varchar(4)
Not null
ISSUE
Issue
Varchar(4)
Not null
DATE
Date published
Date(YYYY-MM- DD)
Not null
VIDEOS: Table to track videos. Please provide a second sentence describing the table describing the PK. Please provide a third table describing tables it has a connection to and any FKs.
Field Name
Description
Data Type
Constraint
PK/FK
VIDEO_NO
Video ID
Int(10)
Not null
PK
COPY_NO
Copy ID
Int(4)
Not null
LEAD_ACTOR
Actors Name
Varchar(50)
Not null
DIRECTOR
Directors Name
Varchar(50)
Not null
TYPE
Movie Genre
Not null
LENGTH
Length
TIME(HH:MM:SS)
Not null
Field Name
Description
Data Type
Constraint
PK/FK
ISBN_NO
ISBN
Varchar(20)
Not null
PK
AUTHOR
Authors name
Varchar(50)
Not null
CATEGORY
Type of book
Varchar(100)
Not null
PUB_NO
Publication Number
Int(10)
Not null
FK
Explanation / Answer
Table : Books- This table contains the details of a Book. It contains the isbn no, pub no, author and category as its attributes.The primary key is isbn no which maintains the unique contraint of the table. The pub no. is the foreign key and referenced to the table Publisher.
Table :Publisher - Gives details of the publishers mainly its name, location and date of publish. The primary key is Pub-no which will be unique for every published article. It is connected to Book table.
Tabe :Newspaper - Consists the details of any newspaper. It is represented by its primary key news no which is unique and not null. It also holds the date at which its published and the brief title of the article. Not conneced with any other tables.
Table: Magazines - Describes the name, volume, issue and date at which a magazine gets published. The primary key is Mag no and it preserves the unique constraint.Not conneced with any other tables.
Table :Videos - Tells us about the type of video and its various characteristics. Can also find out who was the lead actor in the video as well as who directed it.A copy no keeps track of the number of copy of the video. Every unique video has a primary key video id. This video id can be further used for DML purposes. Not conneced with any other tables.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.