Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Convert ERD to Relational Data Model

Make a Relational Data Model to implement a business state that is describeed by using an Entity Relationship Diagram and text. You are to use only the attributes listed in each problem. You might add associative tables, if the implementation needs it.
Each of the RDM explanations is to be in text format as shown:

Table_Name( attribute_1, attribute_2, attribute_3, … ,attribute_x)
Primary Key (attribute_1, attribute_2)
Foreign Key attribute_4 References Table_Name_2 (repeat for each foreign key)
Alternate Key (attribute_5, attribute_6) (repeat for each alternate key)

problem 1: Bluegum Childcare has numerous nurseries, comprising Wagga Wagga, Bathurst, Albury, Orange, and Mudgee. Each nursery is known by its campus code, ex: WW, B, A, O and M correspondingly. Additionally a unique nursery id is assigned to each nursery. Staff members are generally situated at one nursery, however might move to the other nursery on occasion.

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

problem 2: Handymen are employed on contract with specific skills. Skills are describeed with a skill_id – a uniquely assigned number, a skill explanation and their qualifications. The skill description should as well be uniquely stored in the database. The system requires being able to list the skills for each contractor as illustrated below:

John Smith, Garden design, lawn mowing, plumbing, Cert. Plumber;
Jane Doe, Painting, carpentry, electrical wiring, Adv. Dip. Industrial Electronics;
Attributes to be comprised in the relational tables are: contractor_id, contractor_fname, contractor_lname, qual_id, skill_id, skill_description, skill_acquired_date, qual_name.

problem 3: Contractors can work on many projects at any one time. One staff member supervises each project. Contractors can stop and restart work on a project and the system must record the details of starting and stopping work on the plan for each contractor.

Attributes to be comprised are staff_id, staff_fname, staff_lname, contractor_id, contractor_fname, contractor_lname, plan_id, plan_name, contractor_work_start_date, contractor_work_end_date

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M98012

Have any Question? 


Related Questions in DBMS

Create a small bank account database with one account table

Create a small Bank Account database with one Account table. The Account table Should have fields for account number, customer last and first names, and current balance. The type of database will be Access .Populate the ...

Database design discusion post and assignmentdiscusion post

Database Design Discusion Post and Assignment Discusion Post: Data as a Corporate Resource and Foreign Keys Please respond to BOTH of the following questions: Question A Discuss how data can be a corporate resource and d ...

Database systems assignment - student enrolment database a

Database Systems Assignment - Student Enrolment Database A. Task Description 1. Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, de ...

Lab assignment working with additional database objectslab

Lab Assignment: Working with Additional Database Objects LAB OVERVIEW Scenario and Summary There is a lot more to a database than just tables and the data in them. A very important part of database security has to do wit ...

Career opportunities in your majorknowledge workers

CAREER OPPORTUNITIES IN YOUR MAJOR Knowledge workers throughout the business world are building their own desktop databases (often called end-user databases or knowledge worker databases). To do so, they must understand ...

Relational database systems comp 1005objective this is an

Relational Database Systems (COMP 1005) Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scen ...

Relational databases with ms access1 create a table

Relational Databases with MS Access 1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run 2) Your code (for the button) will dynamically read the caption from the table and assign it t ...

Benefits of data protection controlsbased on what you have

Benefits of Data Protection Controls Based on what you have learned about data protection in an online environment, prepare a 5-slide presentation to a department head or the CEO of a company to convince the audience tha ...

Ngocbo database projectthe purpose of this project is to

NGO/CBO Database Project The purpose of this project is to build a database to store and retrieve basic information on NGOs/CBOs collected through a questionnaire given in the Appendix. Database Specifications In view of ...

Data analysis assignment- apriori analysis and cluster

Data Analysis assignment- ApriorI analysis and Cluster analysis CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" s ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen