MyAssignmentServices uses cookies to deliver the best experience possible. Read more

Table of Contents

Task 1.

Task 2A..

Relational Database.

Task 2B. Create Table Students.

Task 3.

Bibliography.

Introduction to Database Fundamentals

This report is regarding the conversion of respective the ER and EER diagram model. Through the presentation of this model the elaboration is being modified as the structure. With the representation of ER diagram with expansion of table names, attributes and specification of the null values and the table identification of primary and secondary key.

Database Fundamentals - Task 1

  • Transformation of ER diagram by using table name, attributes name, primary keys, and foreign keys.

Table name

Attribute Name

Primary Key

Foreign Key

Corporate

Corporation Name,

Business Address

   

Individual

Property Owner

   

Client

Client Address,

Client phone,

Client name,

Client Email

Client No

 

Contract

Start Date,

End Date

   

Suburb

Suburb Name

Postcode

 

Invoice

Amount

Invoice No

 

Industry

Industry Title

Industry ID

 

Union

Union title,

Union contract name,

Union contract number,

Union Email,

Union Address

Union ID

 

Job

Job Description,

Job Address,

Urgency Level,

Job ID

 

Elite Member

 

Elite Member ID

 

Business

Business Postcard,

Business Name,

Contact Name,

Contact number,

Contact Email,

Business Address

ABN Number

 

Career Seminar

Seminar Title,

Seminar Date Time,

Seminar Venue

Seminar ID

 

Task 2A - Relational Database

ID

Name

Age

Salary

1

Adam

34

13000

2

Alex

28

15000

3

Stuart

20

18000

4

Ross

42

19020

Here the 1:1 and 1 many keywords have been considered as there are the specific keywords available here.

Task 2B - Create Table Students

INSERT INTO STUDENTS (STUDENT_ID INTEGER (20) NOT NULL PRIMARY KEY, NAME VARCHAR (20) NOT NULL, ADDRESS VARCHAR (200) NOT NULL, CLASS VARCHAR (50) NOT NULL)

VALUES (“DAVID ROY”, “1/2 G.C ROAD”, “8”)

VALUES (“JASON ROY”, “1/2 R.C ROAD”, “9”)

VALUES (“ANDREW REW”, “2C ROAD”, “8”));

ALTER TABLE STUDENTS;

Database Fundamentals - Task 3

INSERT INTO STUDENTS (STUDENT_ID INTEGER (20) NOT NULL PRIMARY KEY, NAME VARCHAR (20) NOT NULL, ADDRESS VARCHAR (200) NOT NULL, CLASS VARCHAR (50) NOT NULL)

VALUES (“Andrew fog”, “1/2 G.C ROAD”, “8”)

VALUES (“Riyad Fawad”, “1/2 R.C ROAD”, “9”)

VALUES (“Andrew Layd”, “2C ROAD”, “8”);

Conclusion

As per this report is been depicted as the key is needed to be described. Regarding the selection of the attributes and the operation of primary and secondary key and the implementation of oracle is needed to me classified. This help to represent the report in a more proper way.

Bibliography for Database Fundamentals

Caldeira, C., Cunha, C., Vaz, A.R., Falcão, A.S., Barateiro, A., Seixas, E., Fernandes, A. and Brites, D., 2017. Key aging-associated alterations in primary microglia response to beta-amyloid stimulation. Frontiers in aging neuroscience9, p.277.

Christianen, M.J., Middelburg, J.J., Holthuijsen, S.J., Jouta, J., Compton, T.J., van der Heide, T., Piersma, T., Sinninghe Damsté, J.S., van der Veer, H.W., Schouten, S. and Olff, H., 2017. Benthic primary producers are key to sustain the Wadden Sea food web: stable carbon isotope analysis at landscape scale. Ecology98(6), pp.1498-1512.

Koutris, P. and Wijsen, J., 2017. Consistent query answering for self-join-free conjunctive queries under primary key constraints. ACM Transactions on Database Systems (TODS)42(2), pp.1-45.

Koutris, P. and Wijsen, J., 2018, May. Consistent query answering for primary keys and conjunctive queries with negated atoms. In Proceedings of the 37th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems (pp. 209-224).

Koutris, P. and Wijsen, J., 2018. Consistent query answering for primary keys in logspace. arXiv preprint arXiv:1810.03386.

Remember, at the center of any academic work, lies clarity and evidence. Should you need further assistance, do look up to our Computer Science Assignment Help

Get It Done! Today

Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
Not Specific >5000
  • 1,212,718Orders

  • 4.9/5Rating

  • 5,063Experts

Highlights

  • 21 Step Quality Check
  • 2000+ Ph.D Experts
  • Live Expert Sessions
  • Dedicated App
  • Earn while you Learn with us
  • Confidentiality Agreement
  • Money Back Guarantee
  • Customer Feedback

Just Pay for your Assignment

  • Turnitin Report

    $10.00
  • Proofreading and Editing

    $9.00Per Page
  • Consultation with Expert

    $35.00Per Hour
  • Live Session 1-on-1

    $40.00Per 30 min.
  • Quality Check

    $25.00
  • Total

    Free
  • Let's Start

Get
500 Words Free
on your assignment today

Browse across 1 Million Assignment Samples for Free

Explore MASS
Order Now

Request Callback

My Assignment Services- Whatsapp Tap to ChatGet instant assignment help

Get 500 Words FREE
Ask your Question
Need Assistance on your
existing assignment order?