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 application development, The database application project (DAP) fo... The database application project (DAP) for this assignment consists of the creation of a fully functional Microsoft Access database application for a real client. I recommend you s

Objectives of database manangement system, OBJECTIVES After going thro... OBJECTIVES After going through this unit you should be capable to: Explain the File Based system and its limitations; Explain the structure of DBMS; Explain the

B+ tree, construct a B+ tree for the following set of key value (2,3,5,7,11... construct a B+ tree for the following set of key value (2,3,5,7,11,19,23,29,31) in ascending order where the pointers that will fit in one node is as follows:A. four B. six C. eigh

Process of adjustment of inheritance, Process of Adjustment of inheritance ... Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.

Express the queries in relational algebra, Question: This question refe... Question: This question refers to the database schema. a) Express the following queries in SQL: (i) Write the SQL code that will create the table Company. Your answer sh

Insert statement reverses storage space and transfers value, A field-groups... A field-groups statement or an insert statement reverses storage space and transfers values. False.

What is a candidate key, What is a candidate key? Minimal super keys ar... What is a candidate key? Minimal super keys are known as candidate keys.

Improved reliability, Improved Reliability: In a centralised DBMS, a server... Improved Reliability: In a centralised DBMS, a server failure stops the operations of the DBMS. Though, a failure at single site of a DDBMS, or a failure of a communication link cr

Write the motivations led to development of oo-dbms, Write the motivations ... Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Define a table in sql known as client for store information, Define a table... Define a table in SQL known as Client that is used to store information about the clients. Define CLIENT_NO as the primary key whose first letter must begin with ‘C'. Also ensure t