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
What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

what is check point in database management system

A table joined with itself is called ? A table joined with itself is known as self join table. Normal 0 false false false EN-IN X-NONE X-NONE


Submit SQL SELECT Statements to demonstrate several reports off your database, according to the following guidelines: You must submit at least 5 SELECT Statements. Each

What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,

write a short note on participation role? Participation role: roles are indicating in E-R diagram by labelling the lines that connect diamonds to rectangles.

What is system catalog or catalog relation? How is better known as? A RDBMS maintains a explanation of all the data that it contains, information about every relation and index

Describe the two types of methods for retrieving rows in Python? Fetchone()- Returns the next row as a sequence Fetch all()- Returns the entire result set like a strin

What is the use of integrity constraints? Integrity constraints make sure that changes made to the database by authorized users do not result in a loss of data consistency. The