XII - D INFORMATICS PRACTICE (MySQL PRACTICALS: PART-A) 2014-15
XII - D INFORMATICS PRACTICE (MySQL PRACTICALS: PART-A) 2014-15 ( JULY) Q.1 Create the following tables in MySQL as per the given constraints. Table: Book Attribute Datatype Constraint ID Integer Primary Key Title Varchar Not Null AuthorId Integer Foreign Key Price Integer Default 100 Table: Author Attribute Datatype Constraint Aid Integer Primary Key Author Varchar Not Null Language Varchar Not Null Sample Data: Book ...