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

What are the two types of indices, What are the two types of indices? T... What are the two types of indices? The two types of indices are:- A)     Dense index B)      Sparse index

Can your organization scan large format documents, Can your organization sc... Can your organization scan large format documents? Yes, large format scanning used for such entities as city plans and blueprints is available. We selected scanners with the ab

How to define a structure with tag name car_table, QUESTION (a) Conside... QUESTION (a) Consider a car database consisting of car model, car make, car origin, Engine capacity, color, cost.

Objectives of data management, what are the topics in data management what are the topics in data management

Responsibilitied of DBA, explain five responsibilities of DBA? explain five responsibilities of DBA?

Describe all integrity constraints which are violated, Consider the two rel... Consider the two relations given below Given that A is the primary key of R, D is the primary key of S and there is a referential integrity among S.A and R.A, discuss all

Sql, example of embedded SQL query example of embedded SQL query

Explain hash file organization, Explain hash file organization? Hash fu... Explain hash file organization? Hash functions a) The distribution is uniform Hash functions assign each bucket the similar number of search -key values from the set of a

What is called as an n-way merge, What is called as an N-way merge? The... What is called as an N-way merge? The merge operation is a generalization of the two-way merge used by the standard in-memory sort-merge algorithm. It merges N runs, so it is k

What is a linked server, What is a Linked Server? Linked Servers is a m... What is a Linked Server? Linked Servers is a method in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With