CSE2DBF Database Management System Assignment Sample

Subject Code : CSE2DBF
University : La Trobe University My Assignment Services is not sponsored or endorsed by this college or university.
Subject Name : IT Computer Science

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 neuroscience, 9, 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. Ecology, 98(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