Database Research Discussion Forum - Create an ERD - IT Computer Science Assignment Help

Download Solution Order New Solution
Assignment Task :

TASK 
Part A: Database Research Discussion Forum  


You are to conduct research about a current or a future database technology and discuss the findings of your research in the Interact 2 Discussion forum. You should submit a minimum of two posts. You are also to comment in the Interact 2 Discussion forum on at least two posts made by other students. Copy the time, date and content of your posts and include them in a MS Word document as part of this assessment. 

  • Two discussion posts of a current or a future database technology and two comments on other students posts  
  • Quality of engagement: 
     

Part B: Data Modelling  
The Phubbing International Conference (PIC) is the main conference for researchers interested in phubbing. As the conference grew, the organisers have decided to implement a relational database to help with the organisation of the conference. Each year the conference is held, PIC organisers need to keep a record of the conference code, dates, conference theme, chair person and registration fee. The conference venue can be used more than once and is identified by venue_id. Other details that should be kept for the venue include maximum seating capacity, seating style, address, and phone number. The PIC organisers also require keeping a record of all conference attendees identified by Attendee_l D. For each attendee, details such as name, phone number and email address are also recorded. Attendees tend to attend more than one conference. Each time an attendee contributes to a discussion, the PIC organisers give him/her a contribution rating, which should be recorded. PIC organisers also require keeping track of all keynote speakers. Details to be recorded for each keynote speaker include Speaker_ID, name, phone number, topic and email address. Keynote speakers can speak at more than one conference. Each conference can have more than one keynote speaker. Each time a keynote speaker speaks at a conference, the PIC organisers give him/her a performance rating, which should be recorded. 
 

Your task 

  1. Create an ERD for the above scenario that describe the current business rules: 
  2. Use Crow's Foot notations and make sure to include all of the following: 

• All entities

• Attributes for each entity

• Primary key and any foreign key attributes for each entity

• The relationships between entities

• The cardinality and optionality of each relationship 

 

 

This IT Computer Science Assignment has been solved by our IT Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.