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

Ask an Expert

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

Write your message here..

Related Questions

Database security, Ask questiwhat is row indicator in database on #Minimum... Ask questiwhat is row indicator in database on #Minimum 100 words accepted#

What is multilevel index, Multilevel Index The Multilevel Index is a m... Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve

N-ary relationship, For every n-ary relationship type R where n>2, we make ... For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti

Describe the static hash file with buckets and chaining, Describe the stati... Describe the static hash file with buckets and chaining and show how insertion, deletion and modification of a record can be performed. In static hash file organization, the wo

Create a database, The database will enable college administrators the abil... The database will enable college administrators the ability to track students initial major. This will help college officials decide how best to prepare students for their goals an

What is magnetic disks, What is magnetic disks?explain it? Magnetic dis... What is magnetic disks?explain it? Magnetic disk provides the bulk of secondary storage of modern computer system. The disk capacity is growing at over 50% per year. But the st

System analysis and Design, difference between MIS and DSS difference between MIS and DSS

Define the third normal form, Define the Third Normal Form: The third ... Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

Define cascading rollback, Define Cascading rollback The phenomenon whe... Define Cascading rollback The phenomenon where a single transaction failure leads to a series of transaction rollbacks is known as Cascading rollback.

What are the situations while dbms should not be used, What are the situati... What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N