- Internal Code :
- Subject Code : CSE2DBF
- University : La Trobe 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