Data Dictionary - how to answer the following questions for each table: p lease
ID: 3843865 • 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.
EMPLOYEE: Table to identify employees. 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
EMP_NO
Employee ID
Int(5)
Not null
PK
EMPLOYEE: Table to identify employees. 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
CARD_NO
Card Membership Number
Int(10)
Not null
PK
EMP_NO
Employee ID
Int(5)
Not null
FK
MEMBER: Table to track Members. 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
RECORD_NO
Checkout Number per item
Int(8)
Not null
PK
CARD_NO
Card Membership Number
Int(10)
Not null
FK
MEDIA_NO
Media ID
Int(30)
Not null
FK
CHECKOUT: Table to track the member’s items checked out. 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
SUPP_NO
Supplier ID
Int(10)
Not null
pk
SUPPLIER: Table to track Suppliers. 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.
EMP_NO
Employee that ordered it
Int(5)
Not null
FK
MEDIA: Table to track media. 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
WARNING_NO
Warning ID
Int(10)
Not null
PK
CARD_NO
Card Membership Number
Int(10)
Not null
FK
WARNING: Table to track warning messages. 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
WARNING_NO
Warning ID
Int(10)
Not null
PK/FK
CARD_NO
Card Membership Number
Int(10)
Not null
PK/FK
PAYMENTS: Table to track payments due. 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
COPY_NO
Copy of AudioBook
Int(4)
Not null
PK
ISBN_NO
ISBN
Varchar(20)
Not null
FK
AUDIO_BOOKS: Table to track audio 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
COPY_NO
Copy of book
Int(4)
Not null
PK
ISBN_NO
ISBN
Varchar(20)
Not null
FK
HARDCOPY_BOOKS: Table to track hardcopy 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.
EMPLOYEE: Table to identify employees. 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
EMP_NO
Employee ID
Int(5)
Not null
PK
Explanation / Answer
Answer to below question:
Employee:
Employee table is EMP_NO is a Primary Key and which is having relation between the
Member and Media table.
Employee_Memebr_Media
{
EMP_NO(Primary Key)
MEDIA_NO(Foreign Key)
}
Member Table:
In Member Table Primary Key is CARD_NP which is not a NULL and Empty.
And here Foreign Key is EMP_NO where Employee table and Member Table has a relation.
where in EMP_NO is a Primary Key in Employee Table which is Foreign Key in Member Table.
Checkout Table:
In Checkout Table RECORD_NO as a Primary Key which is not to be NULL and Empty.
and here relation is exit between Member table and Media Table.
where CARD_NO as a Primary Key in Member table
and MEDIA_NO as Primary key in Media Table, these two are Foreign keys in Checkout Table.
Supplier Table:
In Supplier Table SUPP_NO as a Primary Key which is not to be NULL and Empty.
And There is Relation is exit Between Media and Supplier.
the third table is
Media_Supplier_Table
{
SUPP_NO(Foreign Key)
MEDIA_NO(Foreign Key)
}
Media Table:
Where Media table has a relation between Employee table and Supplier table.
The table is having the Foreign Keys EMP_NO, SUPP_NO.
Media_Supplier_Employee_Table
{
EMP_NO(Foreign Key)
SUPP_NO(Foreign Key)
MEDIA_NO(Primary Key)
}
Warning Table:
In Warning Table WARN_NO as a Primary Key and which is not to be null and empty.
and CARD_NO is Foreign Key which is from Member table.
Relation between warning and Member table is if Member is getting warning.
Payments Table:
In Payments Table both WARN_NO and CARD_NO together act as a primary key for Payments Table.
Payments table is having a connection between Member and Warning table.
Audio Table:
In Audio Table COPY_NO is a primary key and it has relation between Media table.
Audio table is have relation between Audio and Books
Audio_Books
{
ISBN_NO(Foreign Key)
COPY_NO(Primary Key)
}
HardCopy_BOOKS:
In HardCopy_BOOKS COPY_NO is a primary key and
HardCopy_BOOKS is have relation between Audio and Books
HardCopy_BOOKS
{
ISBN_NO(Foreign Key)
COPY_NO(Primary Key)
}
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.