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

Data warehouses and data martswrite a one- to two-page

Data Warehouses and Data Marts Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts t ...

Task - overview of business casealive amp boating aampb is

Task - Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the avai ...

Your team is a consulting company that specializes in rapid

Your team is a consulting company that specializes in rapid application development. A client company wishes to improve their customer data and interactions records. You create a simple customer relationship system for t ...

Learning outcomes1 manage user access and user profiles

Learning Outcomes 1. Manage user access and user profiles within a complex DBMS 2. Conduct database audits 3. Develop backup and recovery procedures Read the given scenario and perform all tasks. You have to answer all q ...

Lab modifying a database design in visiothis assignment

Lab: Modifying a Database Design in Visio This assignment contains two Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Use "Appendix A: De ...

Discussion questionsdatabase programs are used to store and

Discussion Questions Database programs are used to store and to retain data for a variety of applications, and are often used in conjunction with Web content to deliver dynamic Web pages. Please respond to all of the fol ...

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 ...

A task descriptionoverviewyour task is to create and test a

A. Task Description Overview Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements that Southern Cross University may ...

Problem 1 please create a plsql procedure to print out the

Problem 1: Please create a PL/SQL procedure to print out the reservation ID, checkin date, and checkout date of reservations made by a guest. The input parameters is the name of the guest. There is no output parameter. P ...

Oracle erp systemsoracle provides erp solutions for

Oracle ERP Systems Oracle provides ERP solutions for mid-size business organizations. For this assignment, you are to write a research report on these ERP solutions. Your report should include: • a description of Oracle ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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