A shop called Wonderful Garments that …

A shop called Wonderful Garments that sells school uniforms maintain a database SCHOOL_UNIFORM as shown below. It consisted of two relations — UNIFORM and PRICE. They made UniformCode as the primary key for UNIFORM relation. Further, they used UniformCode and Size as composite keys for PRICE relation. By analysing the database schema and database state, specify SQL queries to rectify the following anomalies. a) The PRICE relation has an attribute named Price. In order to avoid confusion, write SQL query to change the name of the relation PRICE to COST. b) M/S Wonderful Garments also keeps handkerchiefs of red color, medium size of `100 each. Insert this record in COST table. c) When you used the above query to insert data, you were able to enter the values for handkerchief without entering its details in the UNIFORM relation. Make a provision so that the data can be entered in COST table only if it is already there in UNIFROM table. d) Further, you should be able to assign a new UCode to an item only if it has a valid UName. Write a query to add appropriate constraint to the SCHOOL_ UNIFORM database. e) ALTER table to add the constraint that price of an item is always greater than zero.

Differentiate between interactive and script mode of python.

8. To find the third largest/smallest number in a list.

1. Which of the following statement is incorrect? (a) 1 Byte 8 bits (c) 1 MB 1024 KB (b) 1 KB 1024 bytes (d) \overline{GB=} 1024 KB

Which memory is termed as "destructive write" but 'non destructive read' memory

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

• Don't post personal information, mobile numbers and other details.
• Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
• Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
• Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Case study questions of chapter 1

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

• Don't post personal information, mobile numbers and other details.
• Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
• Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
• Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Define each of the following 1.byte 2.kilobyte 3.megabyte 4.gigabyte 5.terabyte

What is the security thread involved when we throw away electronic gadgets that are non functional

Differentiate between displaying and printing method in Python