convert erd to rdm model, Database Management System

Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additionally a unique nursery id is assigned to each nursery. Staff members are usually located at one nursery, but may move to another nursery on occasion.

Attributes to be included in the relational tables are nursery_name, nursery_id, nursery_address, nursery_code, staff_id, staff_fname, staff_lname, staff_employ_date.


Posted Date: 4/3/2013 5:03:57 AM | Location : Australia







Related Discussions:- convert erd to rdm model, Assignment Help, Ask Question on convert erd to rdm model, Get Answer, Expert's Help, convert erd to rdm model Discussions

Write discussion on convert erd to rdm model
Your posts are moderated
Related Questions
Explain Candidate Key and Super Key A super key is a set of one or more than attributes that, taken collectively, permits us to identify uniquely a tuple in the relation. Wher

Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

What is a relationship called when it is maintained between two entities? A relationship is called Binary relationship when it is maintained between two entities.

Do you have experts of the dbms

What is a transaction ? The Transaction is a unit of data processing. For instance, many of the transactions at a bank may be withdrawal or deposit of money; transfer of money f

What is DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

courier company er-diagram

Differentiate between Key and superkey? Key and superkey - A key a single attribute or a combination of two or more attributes of an entity set in which is used to identify o

Using Relational Algebra which query finds customers, who have a balance of over 1000 ? Using Relational Algebra Π Customer_name( σ balance >1000(Deposit)) is query to find cu

Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.