Implement the above schema with its attributes and relation. • Drop the column PAdress from the above Person table. • Change the column PDesignation from above PersonOfficeDetails table VARCHAR (20) to VARCHAR (30). • Change the data type/definition of column POfficeAdress INT to TEXT from above PersonOfficeDetails table. • Rename Person Table to Person_AlterTable. • Insert one meaning full data on each table of your choice

EBK JAVA PROGRAMMING
9th Edition
ISBN:9781337671385
Author:FARRELL
Publisher:FARRELL
Chapter11: Advanced Inheritance Concepts
Section: Chapter Questions
Problem 3PE
icon
Related questions
icon
Concept explainers
Question

Implement the above schema with its attributes and relation.
• Drop the column PAdress from the above Person table.
• Change the column PDesignation from above PersonOfficeDetails table VARCHAR (20) to
VARCHAR (30).
• Change the data type/definition of column POfficeAdress INT to TEXT from above
PersonOfficeDetails table.
• Rename Person Table to Person_AlterTable.
• Insert one meaning full data on each table of your choice

Person
? CNIC INT(13)
O PFname VARCHAR(15)
O PLnam e VARCHAR(15)
O PAddress TEXT
OD.OB DATE
Indexes
PersonOfficeDetails
• CNIC INT(13)
POID INT (11)
O POfficeNam e VARCHAR (35)
OPOfficeAddress INT
O PDesignaton VARCHAR (20)
KO PSalary INT
O PCabinNumber INT
O Poficetours TIME
OPJoiningDate DATE
Indexes
Transcribed Image Text:Person ? CNIC INT(13) O PFname VARCHAR(15) O PLnam e VARCHAR(15) O PAddress TEXT OD.OB DATE Indexes PersonOfficeDetails • CNIC INT(13) POID INT (11) O POfficeNam e VARCHAR (35) OPOfficeAddress INT O PDesignaton VARCHAR (20) KO PSalary INT O PCabinNumber INT O Poficetours TIME OPJoiningDate DATE Indexes
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT