ERD, Database Management System

The entity type STUDENT has the following attributes:
Student Name, Address, Phone, Age, Activity, and No of
Years. Activity represents some campus-based student
activity, and No of Years represents the number of years the
student has engaged in this activity. A given student may
engage in more than one activity. Draw an ERD for this situation.
What attribute or attributes did you designate as the
identifier for the STUDENT entity? Why?
Posted Date: 10/29/2014 1:02:15 PM | Location : Pakistan







Related Discussions:- ERD, Assignment Help, Ask Question on ERD, Get Answer, Expert's Help, ERD Discussions

Write discussion on ERD
Your posts are moderated
Related Questions
Explain the B + tree? B + tree is a type of tree which denotes sorted data in a way that permits for efficient insertion, retrieval and removal of records, each of which is

Consider the subsequent relations RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent) VIEWING(rno, pno, date, comment) PROPERTY_FOR_RENT( pno, street, area ,city,

Designing the fields in the data base The following are the considerations one has to remain in mind while designing the fields in the data base. Coding, compression, en

Compare the Nested-loop join and block-nested loop join Ans: Nested  loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r   where b

Do NOT use the timestamp type.  Use separate date and time data types only.  Figure out how to define an SQL insert statement that uses built-in SQL (or MySQL) functions to define

Consider the following relational schema: Doctor(DName,Reg_no) Patient(Pname, Disease) Assigned_To (Pname,Dname) Give expression in both Tuple calculus and Domain calculus for


What is 2NF? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML

A basic model of Database Access Control Models of database access control have grown out of previous work on protection in operating systems. Let us talk about one simple mode