Consider the following schema related to a Social Media website named as ‘userPosts’.

computer science

Description

Question No. 1


Consider the following schema related to a Social Media website named as ‘userPosts’. You have to perform following tasks related to the provided schema:

 

1-      Identify appropriate keys for following structure (Primary and/or foreign key(s))

2-      Convert this schema into 2 NF

userPosts (userID, userName, password, address, postId, postDate, postContent)

 

 

Question No. 2

Consider the following schemas relevant to a hotel booking website. You are required to De-Normalization the given schemas using Collapsing Tables Technique.

 

roomVisitor (roomID, visitorCNIC, dateTime)

 

roomCharges (roomID, spentDays, roomRent)


Related Questions in computer science category