how does it differ from the white kkdata schema compare to the kkdata6. This is

Question

how does it differ from the white kkdata schema compare to the kkdata6. This is database;

mysgl> describe kkdata6 Field. Nu11 Type work no int (11) YES art first varchar (34) YES art last varchar (34) YES gertitle varchar (79) YES engtitle varchar (79) YES datemonth varchar (9) YES date year varchar (5) YES datetext varchar (60) YES varchar (200) l YES medium dimh varchar (6) YES dimw varchar (6) YES credit varchar (200) YES varchar (77) YES Own name own address varchar (77) YES own city varchar (33) YES varchar (9) YES Own zip varchar (33) own country YES ownphonel varchar (13) YES place varchar (38) YES repd varchar (78) YES catrais varchar (76) YES housecat varchar (76) YES other title varchar (79) YES firstmo varchar (16) YES lastmod varchar (16) YES ex date varchar (8) YES ex place varchar (50) YES varchar (10) YES ex no varchar (10) I YES ex illust refs publication l varchar (50) YES varchar (16) I YES refs reference refs illust varchar (10) YES 32 rows in set (0.00 sec) Key Default l Extra NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

Explanation / Answer

Following are differences:

1) Starting with basic difference there are more columns in kkdata6(32 columns) as compared with kkdata(30 columns)

2) Columns missing in kkdata from kkdata6 are : ex_date,ex_place,ex_no,ex_illust,refs_publication,refs_reference,refs_illust

3) Additional columns found in kkdata are: oldworkno,needtofind,needtowork,lnrq,lnsq

4) First Field in kkdata6 (workno) does not have primary key which is given in kkdata ( A primary key is defined to proivde unique identification to column and values inside this filed cannot be repetative or null, for that we can provide an autoincrement feature to be turned ON so that values in workno will automatically increment by 1 or user defined increment. It is always better to provide primary key to tables)

5) We cannot make kkdata6 joinable with other table as it is missing primary key field where as it is possible with kkdata

6) Fields in kkdata like 'needtofind','needwork','lnrq','lnsc' all of have data type char(1) which means that if we want to define a single character value or flag, it can be defined inside these field(e.g.0/1, Y/N) This is very important as these fields will not have more than single character value hence defining it as varchar will occupy unnecessary memory.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.