Design the Relational Schema for the E-R diagram that you have drawn for Question 1. The relations must be at least in 3NF. Perform the following on the relations:
Enter about 5 sets of meaningful data in each of the relations.
Identify the domain of various attributes.
Identify the Primary key of every relation.
Identify the Foreign keys and referential integrity constraints in the relations.
See Answer →
विशेष श्रोता रेडियो कार्यक्रमों की अवधारणा को स्पष्ट करें। रेडियो पर किसानों के कार्यक्रमों की प्रासंगिकता पर चर्चा करें।
See Answer →जल संरक्षण' और 'सबके लिए शिक्षा' पर दो सार्वजनिक सेवा घोषणाओं (पी.एस.ए.) के लिए स्क्रिप्ट तैयार करें।
See Answer →रेडियो समाचार बुलेटिन
See Answer →रेडियो साक्षात्कार
See Answer →रेडियो परिचर्चा
See Answer →रेडियो पत्रिका
See Answer →Design an ER diagram for a University, which manages the students, Programmes, courses and student results. You should clearly identify the entities, relationships, relationship cardinality and key constraints in your answer. You must also add proper attributes for each entity. A brief description of the University is given below. Make suitable assumptions.
A University allows students to register for its programmes offered during an Academic year. The academic year starts in July and ends in June. All the programmes of the University are of 1-year duration. Each programme consists of 5 compulsory courses of 4 credits each. A student is given an account on the University MIS, where s/he can see her/his result. University conducts the examinations at the end of the academic year. A student is declared passed in a course if she secures 50% marks in the examination of that course. A student must pass all the courses of the programme in which she has registered. The students who have passed their programme are awarded a certificate during a convocation, which is held once a year.
See Answer →खराब प्रस्तुति पूरे बाजार अनुसंधान अभ्यास को पूर्ववत कर देगी।
See Answer →
विदेशी बाजारों के चयन में क़ानूनी स्थितियों का विश्लेषण एक बहुत ही महत्वपूर्ण घटक है।
See Answer →प्रत्यक्ष और अप्रत्यक्ष विक्रय चैनल
See Answer →व्यक्तिगत विक्रय
See Answer →गैट्स (GATS)
See Answer →