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

The discussion questionbased on your research and readings

The discussion question Based on your research and readings for the week, respond to the following discussion topics. • Often, systems have only one level of security when it comes to databases. Imagine that someone is 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 ...

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

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

Question - databasesuse database software such as microsoft

Question - Databases Use database software such as Microsoft Access or LibreOffice Base to perform the following actions. (Refer to Workshops 9 & 10 for help.) A. Create a new database. Add tables based on the design of ...

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

Case problem-global site gps - kevin hodge is a production

Case Problem- Global Site GPS - Kevin Hodge is a production assistant at Global Site GPS, a leading manufacturer of GPS devices located in Crestwood, Missouri. One of Kevin's jobs is to monitor output at the company's fi ...

Database design assignmentpart 1customer resource

Database Design Assignment Part 1 Customer Resource Management Database You have been tasked to develop a set of tables for a customer resource management database. You are required to store the following information in ...

  • 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