English

For the above-given database STUDENT-PROJECT, can we perform the following operation? Insert a project detail without a submission date. -

Advertisements
Advertisements

Question

Student Project Database
Table: STUDENT
Roll No Name Class Section Registration_ID
11 Mohan XI 1 IP-101-15
12 Sohan XI 2 IP-104-15
21 John XII 1 CS-103-14
22 Meena XII 2 CS-101-14
23 Juhi XII 2 CS-101-10
Table: PROJECT
ProjectNo PName SubmissionDate    
101 Airline Database 12/01/2018    
102 Library Database 12/01/2018    
103 Employee Database 15/01/2018    
104 Student Database 12/01/2018    
105 Inventory Database 15/01/2018    
106 Railway Database 15/01/2018    
PROJECT ASSIGNED      
Registration_ID ProjectNo      
IP-101-15 101      
IP-104-15 103      
CS-103-14 102      
CS-101-14 105      
CS-101-10 104      

For the above-given database STUDENT-PROJECT, can we perform the following operation?

Insert a project detail without a submission date.

One Word/Term Answer

Solution

Yes

shaalaa.com
Relational Data Model
  Is there an error in this question or solution?
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×