CSE2DBF Database Management System Assignment Sample

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.

Task 2A - Relational Database

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

Looking For Complete Assignment Sample Get It On WhatsApp