Course Hero Logo

20BCE2752_VL2021220104333_FAT.pdf - DBMS LAB FAT REG.NO:...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 10 out of 10 pages.

DBMS LAB FATREG.NO:20BCE2752NAME:AATHIRAINATHAN PDATE:08-12-2021SLOT:L13+L141)a)With the given data types and constraints, the two relations instructor and departmentwere created which is shown in the below image.
b)Insert“MGBlock,CSE,50LWhile inserting this tuple we got the above error due to thePrimary Keyconstraint of Deptname. As the DeptnameCSEis already present in theDepartment relation we are unable to insert it again.
InsertSJTAnnex,CHE,16L:This insertion is successful as it does not violate the Primary key constraint likethe previous insertion.
c) New relation: Dept_Instcount
The above images show the query and output of the new relation created.d) Update the tuple of Dept_Instcount:
Here there is no update in theBudget

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 10 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
professor_unknown
Tags
Relational model, 50l, 16l

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture