Create Tables For Music School

Student_Info table

A student book and join one or many classes. A class is booked and joined by one or many students.

• According to the case study classes are divided into two types of classes. One is children class and other is adult class. So that here classes are superclass and children and the adult are subclasses.
• A musician work as one and only one teach musician and each teaches musician is related to one and only one musician.
• A teach musician teach one or many classes and each class is related to one and only one teach musician.
• A teach musician book one or many lessons and each lesson booked by one or many teach musician.
• A lesson has one or many classes and each class is related to one and only one lesson.
• According to the case study music, the list is divided into two types of list. One is live music list and other is teaching music list. So that here music list is super class and live music list and teach music list are subclasses.
• A teach music list has one or many lessons and each lesson is related to one and only one teach music list.
• Avenue book one or many bands and each band booked by one or many bands.
• A musician arranges and books many venues.
• Booking venue contains the information related to the musician, live performance and band booking.

 Task 2: –

——————-1. Student_Info table——————–

Create Table Student_Info

Student_ID varchar2 (5) not null,

First_Name varchar2 (20) not null,

Last_Name varchar2 (20) not null,

DOB date not null,

Gender varchar2 (1) not null check ( Gender in (‘M’,’F’)),

Address varchar2 (100) not null,

Phone varchar2 (12) not null,

Email varchar2 (50) not null,

primary key (Student_ID)

————–2. Musician_Info table——————–

Create table Musician_Info

Musician_ID varchar2 (5) not null,

First_Name varchar2 (20) not null,

Last_Name varchar2 (20) not null,

DOB date not null,

Gender varchar2 (1) not null check (Gender in (‘M’, ‘F’)),

Location varchar2 (20) not null,

Address varchar2 (100) not null,

Phone varchar2 (12) not null,

Email varchar2 (50) not null,

Primary key (Musician_ID)

————-3. Teach_Musician table——————–

Create table Teach_Musician

Teach_Musician_ID varchar2 (5) not null,

WWCC varchar2 (10) not null,

Start_Date date not null,

Expiry_Date date not null,

Join_Date date not null,

Primary key (Teach_Musician_ID),

foreign key (Teach_Musician_ID) references Musician_Info(Musician_ID)

—————-4. Music_List table——————–

Create table Music_List

Music_No varchar2 (5) not null,

Music_Type varchar2 (20) not null Check (Music_Type in (‘Live Music’, ‘Teach Music’)),

Music_Name varchar2 (100) not null,

primary key (Music_No) 

————5. Live_Music_List table——————–

create table Live_Music_List

Live_Music_No varchar2 (5) not null,

Primary key (Live_Music_No),

foreign key (Live_Music_No) references Music_List(Music_No)

—————6. Teach_Music_List table——————–

create table Teach_Music_List

Teach_Music_No varchar2 (5) not null,

Primary key (Teach_Music_No),

foreign key (Teach_Music_No) references Music_List(Music_No)

————-7. Lesson table——————–

create table Lesson

Lesson_No varchar2 (5) not null,

Lesson_Name varchar2 (100) not null,

Teach_Music_No varchar2 (5) not null,

Style_Of_Music varchar2 (100) not null,

primary key (Lesson_No),

foreign key (Teach_Music_No) references Teach_Music_List(Teach_Music_No)

—————-8. Lesson_Booking table——————–

Create table Lesson_Booking

Lesson_Booking_No varchar2 (5) not null,

Lesson_No varchar2 (5) not null,

Teach_Musician_ID varchar2 (5) not null,

Booking_Date date not null,

primary key (Lesson_Booking_No),

foreign key (Lesson_NO) references Lesson(Lesson_No),

foreign key (Teach_Musician_ID) references Teach_Musician(Teach_Musician_ID)

—————-9.  Classes table——————–

create table Classes

Class_No varchar2 (5) not null,

Class_Type varchar2 (20) not null check (Class_Type in (‘Children’,’Adults’)),

Class_Name varchar2 (100) not null,

Start_DateTime TIMESTAMP not null,

End_DateTime TIMESTAMP not null,

Room_Number varchar2 (10) not null,

Teach_Musician_ID varchar2 (5) not null,

Lesson_No varchar2 (5) not null,

Total_Students integer not null,

primary key (Class_No),

foreign key (Teach_Musician_ID) references Teach_Musician(Teach_Musician_ID),

foreign key (Lesson_No) references Lesson(Lesson_No)

————-10. Join_Class table——————–

create table Booking_Join_Class(

Booking_Join_Class_No integer not null,

Student_ID varchar2 (5) not null,

Class_No varchar2 (5) not null,

Join_Date date not null,

Musician_Info table

Booking_Date date Not null,

primary key (Booking_Join_Class_No),

Foreign key (Student_ID) references Student_Info(Student_ID),

foreign key (Class_No) references Classes(Class_No)

—————-11. Children_Class table——————–

create table Children_Class

Class_No varchar2 (5) not null,

primary key (Class_No),

foreign key (Class_No) references Classes(Class_No)

—————12. Adult_Class table——————–

create table Adult_Class

Class_No varchar2 (5) not null,

primary key (Class_No),

foreign key (Class_No) references Classes(Class_No)

————13. Venue table—————————-

create table Venue

Venue_No varchar2 (5) not null,

Name varchar2 (100) not null,

Start_DateTime TIMESTAMP not null,

End_DateTime TIMESTAMP not null,

Location varchar2 (50) not null,

primary key (Venue_No)

—————-14. Band table——————–

create table Band

Band_No varchar2 (5) not null,

Band_Type varchar2 (100) not null,

Band_Name varchar2 (100) not null,

Total_Members integer not null,

primary key (Band_No)

—————15. Band_Booking table——————–

create table Band_Booking

Band_Booking_No integer not null,

Venue_No varchar2 (5) not null,

Band_No varchar2 (5) not null,

Booking_Date date not null,

Primary key (Band_Booking_No),

foreign key (Venue_No) references Venue(Venue_No),

foreign key (Band_No) references Band(Band_No)

—————–16. Live_Performance table——————–

create table Live_Performance

S_No integer not null,

Name varchar2 (100) not null,

Live_Music_No varchar2 (5) not null,

LP_Date date not null,

primary key (S_No),

foreign key (Live_Music_No) references Live_Music_List(Live_Music_No)

——————17. Booking_Venue table——————–

create table Booking_Venue

Booking_Venue_No integer not null,

S_No integer not null,

Band_Booking_No integer not null,

Booking_Date date not null,

Musician_ID varchar2(5) not null,

primary key (Booking_Venue_No),

foreign key (S_No) references Live_Performance(S_No),

foreign key (Band_Booking_No) references Band_Booking(Band_Booking_No),

foreign key (Musician_ID) references Musician_Info(Musician_ID)

2.2           Insert data into tables: –

——————-1. Student_Info table——————–

Insert into Student_Info values (‘101′,’XY’,’YI’,’01-JAN-1995′,’M’,’US’,’6789878987′,’[email protected]‘);

insert into Student_Info values (‘102′,’XQ’,’YI’,’01-JAN-1995′,’F’,’US’,’6789878965′,’[email protected]‘);

insert into Student_Info values (‘103′,’XE’,’YI’,’01-JAN-1995′,’M’,’US’,’6568678987′,’[email protected]‘);

insert into Student_Info values (‘104′,’XR’,’YI’,’01-JAN-1995′,’F’,’US’,’9089878987′,’[email protected]‘);

insert into Student_Info values (‘105′,’XT’,’YI’,’01-JAN-1995′,’M’,’US’,’6785678987′,’[email protected]‘);

insert into Student_Info values (‘106′,’XU’,’YI’,’01-JAN-1995′,’M’,’US’,’6235878987′,’[email protected]‘);

————–2. Musician_Info table——————–

insert into Musician_Info values (‘M101′,’TY’,’KL’,’01-JAN-1992′,’M’,’Victoria’,’US’,’8979878980′,’[email protected]‘);

insert into Musician_Info values (‘M102′,’TQ’,’KL’,’01-JAN-1993′,’M’,’Victoria’,’US’,’6734558980′,’[email protected]‘);

insert into Musician_Info values (‘M103′,’TW’,’KL’,’01-JAN-1994′,’F’,’Victoria’,’US’,’7886778980′,’[email protected]‘);

insert into Musician_Info values (‘M104′,’TE’,’KL’,’01-JAN-1995′,’F’,’Victoria’,’US’,’8767878980′,’[email protected]‘);

insert into Musician_Info values (‘M105′,’TR’,’KL’,’01-JAN-1996′,’M’,’Victoria’,’US’,’2346878980′,’[email protected]‘);

insert into Musician_Info values (‘M106′,’TT’,’KL’,’01-JAN-1997′,’M’,’Victoria’,’US’,’5678878980′,’[email protected]‘);

————-3. Teach_Musician table——————–

insert into Teach_Musician values (‘M101′,’678′,’19-JAN-2012′,’19-DEC-2019′, ’15-JAN-2012’);

insert into Teach_Musician values (‘M102′,’671′,’10-JAN-2012′,’10-DEC-2019′, ’10-JAN-2012’);

insert into Teach_Musician values (‘M103′,’672′,’11-JAN-2012′,’11-DEC-2019′, ’11-JAN-2012’);

insert into Teach_Musician values (‘M104′,’673′,’12-JAN-2012′,’12-DEC-2019′, ’12-JAN-2012’);

insert into Teach_Musician values (‘M105′,’674′,’13-JAN-2012′,’13-DEC-2017′, ’13-JAN-2012’);

insert into Teach_Musician values (‘M106′,’675′,’14-JAN-2012′,’14-DEC-2017′, ’14-JAN-2012’);

—————-4. Music_List table——————–

insert into Music_List values (‘MU101′,’Live Music’,’yughj’);

insert into Music_List values (‘MU102′,’Live Music’,’fhhjjk’);

insert into Music_List values (‘MU103′,’Live Music’,’vhgjk’);

insert into Music_List values (‘MU104′,’Teach Music’,’udgh’);

insert into Music_List values (‘MU105′,’Teach Music’,’dfcgyn’);

insert into Music_List values (‘MU106′,’Teach Music’,’jggdhj’);

————5. Live_Music_List table——————–

insert into Live_Music_List values (‘MU101’);

insert into Live_Music_List values (‘MU102’);

insert into Live_Music_List values (‘MU103’);

—————6. Teach_Music_List table——————–

insert into Teach_Music_List values (‘MU104’);

Teach_Musician table

insert into Teach_Music_List values (‘MU105’);

insert into Teach_Music_List values (‘MU106’);

————-7. Lesson table——————–

insert into Lesson values (‘L101′,’POP’,’MU104′,’POP’);

insert into Lesson values (‘L102′,’ROCK’,’MU105′,’ROCK’);

insert into Lesson values (‘L103′,’JAZZ’,’MU106′,’JAZZ’);

insert into Lesson values (‘L104′,’CLASSIC’,’MU104′,’CLASSIC’);

insert into Lesson values (‘L105′,’POP1′,’MU105′,’POP’);

insert into Lesson values (‘L106′,’POP2′,’MU106′,’POP’);

—————-8. Lesson_Booking table——————–

insert into Lesson_Booking values (‘1′,’L101′,’M101′,’01-sep-2018’);

insert into Lesson_Booking values (‘2′,’L102′,’M102′,’02-sep-2018’);

insert into Lesson_Booking values (‘3′,’L103′,’M103′,’03-sep-2018’);

insert into Lesson_Booking values (‘4′,’L104′,’M104′,’04-sep-2018’);

insert into Lesson_Booking values (‘5′,’L105′,’M105′,’05-sep-2018’);

insert into Lesson_Booking values (‘6′,’L106′,’M106′,’06-sep-2018’);

—————-9. Classes table——————–

insert into Classes values (‘C101′,’Children’,’UIHJN’,’01-Sep-2018 09:50:16.78′,’01-Sep-2018 11:50:16.78′,’R101′,’M101′,’L101′,’23’);

insert into Classes values (‘C102′,’Children’,’GHGHJ’,’02-Sep-2018 09:50:16.78′,’02-Sep-2018 11:50:16.78′,’R102′,’M102′,’L102′,’24’);

insert into Classes values (‘C103′,’Children’,’MNNBV’,’03-Sep-2018 09:50:16.78′,’03-Sep-2018 11:50:16.78′,’R103′,’M103′,’L103′,’25’);

insert into Classes values (‘C104′,’Adults’,’GHVNH’,’04-Sep-2018 09:50:16.78′,’04-Sep-2018 11:50:16.78′,’R104′,’M104′,’L104′,’26’);

insert into Classes values (‘C105′,’Adults’,’CVBHG’,’05-Sep-2018 09:50:16.78′,’05-Sep-2018 11:50:16.78′,’R105′,’M105′,’L105′,’27’);

insert into Classes values (‘C106′,’Adults’,’BNHGU’,’06-Sep-2018 09:50:16.78′,’06-Sep-2018 11:50:16.78′,’R106′,’M106′,’L106′,’28’);

————-10. Join_Class table——————–

insert into Booking_Join_Class values (1,’101′,’C101′,’01-JULY-2018′,’01-JAN-2018′);

insert into Booking_Join_Class values (2,’102′,’C102′,’02-JULY-2018′,’02-JAN-2018′);

insert into Booking_Join_Class values (3,’103′,’C103′,’03-JULY-2018′,’03-JAN-2018′);

insert into Booking_Join_Class values (4,’104′,’C104′,’04-JULY-2018′,’04-JAN-2018′);

insert into Booking_Join_Class values (5,’105′,’C105′,’05-JULY-2018′,’05-JAN-2018′);

insert into Booking_Join_Class values (6,’106′,’C106′,’06-JULY-2018′,’06-JAN-2018′);

insert into Booking_Join_Class values (7,’101′,’C101′,’07-JULY-2018′,’07-JAN-2018′);

insert into Booking_Join_Class values (8,’102′,’C102′,’08-JULY-2018′,’08-JAN-2018′);

insert into Booking_Join_Class values (9,’103′,’C103′,’09-JULY-2018′,’09-JAN-2018′);

insert into Booking_Join_Class values (10,’104′,’C104′,’10-JULY-2018′,’10-JAN-2018′);

insert into Booking_Join_Class values (11,’105′,’C105′,’11-JULY-2018′,’11-JAN-2018′);

insert into Booking_Join_Class values (12,’106′,’C106′,’12-JULY-2018′,’12-JAN-2018′);

—————-11. Children_Class table——————–

insert into Children_Class values (‘C101’);

insert into Children_Class values (‘C102’);

insert into Children_Class values (‘C103’);

—————12. Adult_Class table——————–

insert into Adult_Class values (‘C104’);

insert into Adult_Class values (‘C105’);

insert into Adult_Class values (‘C106’);

————13. Venue table—————————-

insert into Venue values (‘V101′,’GHJB’,’01-SEP-108′,’02-SEP-2018′,’Australian’);

insert into Venue values (‘V102′,’GHJB’,’02-SEP-108′,’03-SEP-2018′,’Australian’);

insert into Venue values (‘V103′,’GHJB’,’03-SEP-108′,’04-SEP-2018′,’Australian’);

insert into Venue values (‘V104′,’GHJB’,’04-SEP-108′,’05-SEP-2018′,’Australian’);

insert into Venue values (‘V105′,’GHJB’,’05-SEP-108′,’06-SEP-2018′,’Australian’);

insert into Venue values (‘V106′,’GHJB’,’06-SEP-108′,’07-SEP-2018′,’Australian’);

—————-14. Band table——————–

insert into Band values (‘B101′,’TY’,’HJBNH’,10);

insert into Band values (‘B102′,’TR’,’HHGKH’,10);

insert into Band values (‘B103′,’TQ’,’MNBV’,10);

insert into Band values (‘B104′,’TE’,’CVBN’,10);

insert into Band values (‘B105′,’TA’,’KJH’,10);

insert into Band values (‘B106′,’TN’,’DFGHJ’,10);

—————15. Band_Booking table——————–

insert into Band_Booking values (1, ‘V101′,’B101′,’01-AUG-2018’);

insert into Band_Booking values (2, ‘V102′,’B102′,’02-AUG-2018’);

insert into Band_Booking values (3, ‘V103′,’B103′,’03-AUG-2018’);

insert into Band_Booking values (4, ‘V104′,’B104′,’04-AUG-2018’);

insert into Band_Booking values (5, ‘V105′,’B105′,’05-AUG-2018’);

insert into Band_Booking values (6, ‘V106′,’B106′,’06-AUG-2018’);

—————–16. Live_Performance table——————–

insert into Live_Performance values (1, ‘hjb’,’MU101′,’01-AUG-2018′);

insert into Live_Performance values (2, ‘HGJ’,’MU102′,’02-AUG-2018′);

insert into Live_Performance values (3, ‘HBN’,’MU103′,’03-AUG-2018′);

insert into Live_Performance values (4, ‘MNNBV’,’MU101′,’04-AUG-2018′);

insert into Live_Performance values (5, ‘HJN’,’MU102′,’05-AUG-2018′);

insert into Live_Performance values (6, ‘LKJ’,’MU103′,’06-AUG-2018′);

——————17. Booking_Venue table——————–

insert into Booking_Venue values (1, 1, 1, ’02-AUG-2018′,’M101′);

insert into Booking_Venue values (2, 2, 2, ’03-AUG-2018′,’M102′);

insert into Booking_Venue values (3, 3, 3, ’04-AUG-2018′,’M103′);

insert into Booking_Venue values (4, 4, 4, ’05-AUG-2018′,’M104′);

insert into Booking_Venue values (5, 5, 5, ’06-AUG-2018′,’M105′);

Music_List table

insert into Booking_Venue values (6, 6, 6, ’07-AUG-2018′,’M106′);

Queries: –

1. Count of all new students who have joined Kevin’s music after the 1st of July 2018.

SELECT COUNT (STUDENT_INFO.STUDENT_ID) AS “TOTAL NUMBER OF STUDENTS”

FROM STUDENT_INFO, BOOKING_JOIN_CLASS

WHERE STUDENT_INFO.STUDENT_ID = BOOKING_JOIN_CLASS.STUDENT_ID

AND BOOKING_JOIN_CLASS.JOIN_DATE>’01-JULY-2018′;

1. List of all underage male musicians and their age sorted by the first name.

SELECT MUSICIAN_ID AS “MUSICIAN ID”,

CONCAT (FIRST_NAME, LAST_NAME) AS “MUSICIAN NAME”,

TRUNC (months_between (sysdate, DOB) / 12) AS “Age”

FROM MUSICIAN_INFO

WHERE TRUNC (months_between(sysdate, DOB) / 12)<25

AND GENDER=’M’

ORDER BY FIRST_NAME;

iii. List of all teachers who have an expired Working With Children Check (WWCC), with names, expiry date and their age, sorted by date.

SELECT CONCAT (MUSICIAN_INFO. FIRST_NAME, MUSICIAN_INFO.LAST_NAME) AS “MUSIC TEACHER NAME”,

TEACH_MUSICIAN.WWCC, TEACH_MUSICIAN.EXPIRY_DATE,

TRUNC (months_between (sysdate, MUSICIAN_INFO.DOB) / 12) AS “Age”

FROM MUSICIAN_INFO, TEACH_MUSICIAN

WHERE MUSICIAN_INFO.MUSICIAN_ID=TEACH_MUSICIAN.TEACH_MUSICIAN_ID

AND TEACH_MUSICIAN.EXPIRY_DATE<SYSDATE

ORDER BY TEACH_MUSICIAN.EXPIRY_DATE;

1. List of all current lesson bookings sorted by the style of music and the booking date (Most recent first). Hint: You may have to join various tables in SQL to achieve the desired output, lookup join command.

SELECT LESSON.LESSON_NAME, LESSON.STYLE_OF_MUSIC, LESSON_BOOKING.BOOKING_DATE

FROM LESSON, LESSON_BOOKING

WHERE LESSON_BOOKING.LESSON_NO = LESSON.LESSON_NO

ORDER BY LESSON_BOOKING.BOOKING_DATE, LESSON.STYLE_OF_MUSIC DESC;

1. (Research Required) A report on the students enrolled, the style of music and the teacher for the current calendar month. Current calendar month refers to the month in which this SQL query is run.

SELECT STUDENT_INFO.STUDENT_ID, CONCAT (STUDENT_INFO.FIRST_NAME, STUDENT_INFO.LAST_NAME) AS “STUDENT NAME” ,

LESSON.STYLE_OF_MUSIC,

CONCAT (MUSICIAN_INFO.FIRST_NAME, MUSICIAN_INFO.LAST_NAME) AS “TEACH MUSICIAN NAME”, CLASSES.START_DATETIME

FROM STUDENT_INFO, CLASSES, BOOKING_JOIN_CLASS, TEACH_MUSICIAN, MUSICIAN_INFO, LESSON, TEACH_MUSIC_LIST

WHERE STUDENT_INFO.STUDENT_ID=BOOKING_JOIN_CLASS.STUDENT_ID

AND TEACH_MUSIC_LIST.TEACH_MUSIC_NO=LESSON.TEACH_MUSIC_NO

AND CLASSES.LESSON_NO=LESSON.LESSON_NO

AND CLASSES.TEACH_MUSICIAN_ID=TEACH_MUSICIAN.TEACH_MUSICIAN_ID

AND CLASSES.CLASS_NO=BOOKING_JOIN_CLASS.CLASS_NO

AND MUSICIAN_INFO.MUSICIAN_ID=TEACH_MUSICIAN.TEACH_MUSICIAN_ID

AND EXTRACT (Month from CLASSES.START_DATETIME) = EXTRACT (month from sysdate);

Research Task

After being alarmed by the recent security incidents reported in the media, Kevin decides to employ a part-time System Administrator to manage system security.

• a) Identify 6 security threats to the proposed system (Choose a mix of internal/external, deliberate/unintentional threats).

1. Unencrypted Sensitive data: –

All the data is stored in plain text. This data also includes some sensitive data that is very personal to Customer or which could be misused by any other person. Such data must not be stored in plain form and should be encrypted before storage.

1. No Auditing: –

No triggers are used in the database. Who updated what and when is not stored anywhere. Any updating or deletions from the database must be monitored. There must be a table that must store the altered data so that it could be retrieved in case of any mistakes.

1. Denial of service : –

Denials of service attacks are very common. Anyone can keep on hitting the database frequently so that it becomes unavailable for others

1. The sensitivity of Backup Data :

The data that is stored as the backup on the internet or some external devices to be used in case of any problems must also not be stored in simple plain form.

1. Authentication System:

The authenticity of a Database System is of great importance. Any user must log in to the database after passing through several authentication procedures. Also, their roles must be defined clearly of what they can do?

1. SQL Injection:

SQL Injection is the act of using various loopholes in the database system to explore or change the data which you don’t have access to. Anyone can use this if our database data is not properly stored

Unencrypted Sensitive data	7	3	Sensitive data is stored in plain text form
No Auditing	7	6	Altered data is not stored
Denial of service	9	3	Frequently heating database to make it unavailable for others
The sensitivity of the Backup System		7	Backup data is stored in plain text form
Authentication System	9	8	Roper layers of authentication are missing.
SQL Injection	7	5	Using SQL programming loopholes to corrupt or steal data

Live_Music_List table

 For each threat which of the risk controls would you recommend? Justify your choice. If you have opted for avoidance or mitigation of risk, clearly explain the policies, measures or strategies that need to be put in place to achieve the desired outcome.

1. Unencrypted Sensitive Data: –

Sensitive data should not be stored in plain text form. It should be stored after proper encryption.

1. No auditing: –

Audit functionality must be there in the database. Any alterations in the database must be properly handled and we must store the backup of the altered data. Any data which is deleted from the main table must be stored in the auditing table.

1. Denial of service : –

Proper rules and policies must be configured on the database, so that denial of service attacks can be stopped. A user must be blocked temporarily or permanently from making these attacks. 

1. The sensitivity of the Backup System: –

Backup data must not be stored in plain text form. It should be stored in encrypted form. Many databases are already taking a step by making policies that backup can be stored in encrypted form only.

1. Authentication System: –

All users must be properly authenticated before logging it into the System. There must be several layers of authentication from which the user must be passed to log in into the System.

1. SQL Injection:

SQL injection is a major culprit of most of the data thefts and data corruption issues. Our database must be configured with proper rules and policies so that it could be protected from any SQL injection attempts. We can use various functions and procedures to protect our database from these attacks. 

Alhir, S. (2003) Learning UML. Sebastopol, Calif.: O’Reilly.

Ambler, S. (2003) The elements of UML style. Cambridge: Cambridge U.P.

Ambler, S. (2005) The elements of UML 2.0 style. Cambridge [U.K.]: Cambridge University Press.

Awad, E. and Gotterer, M. (1992) Database management. Danvers, Mass.: Boyd & Fraser Pub. Co.

Belloc, H. (1967) On. Freeport, N.Y.: Books for Libraries Press.

Broad, W. (2007) Oracle. Penguin Group US.

Dennis, A., Wixom, B. and Tegarden, D. (2015) Systems Analysis and Design. New York: Wiley.

ELIOT, G. (2018) MILL ON THE FLOSS. [S.l.]: ALMA CLASSICS.

Harmon, P. and Sawyer (1999) UML for Visual Basic 6.0 Developers. San Francisco, Cal.: Morgan Kaufmann.

Holt, J. (2007) UML for systems engineering. London: The Institution of Electrical Engineers.

Kimmel, P. (2011) UML demystified. New York: McGraw Hill Professional.

Li, D. (1987) A PROLOG database system. Letchworth Herts.: Research Studies Press.

Mason, D. and Willcocks, L. (1994) Systems analysis, systems design. Henley-on-Thames: A. Waller.

Naiburg, E. and Maksimchuck, R. (2002) UML for database design. Boston: Addison-Wesley.

Obermair, W. (1995) Extending the object-oriented database management system VODAK with active capabilities. Sankt Augustin: GMD.

Oracle (1995) The Oracle speaks. Auckland, N.Z.: Oracle Productions.

PATHAK, N. (2011) DATABASE MANAGEMENT SYSTEM. [S.l.]: HIMALAYA PUBLISHING HOUSE.

Ramarkrishnan, R. (1997) Database management system. London: McGraw-Hill Pub. Co. (ISE Editions).

Satzinger, J., Jackson, R. and Burd, S. (2016) Systems analysis and design in a changing world. Boston: Cengage Learning.

Watson, I. (1998) Oracle. London: Vista.

Weilkiens, T. and Oestereich, B. (n.d.) UML 2 Certification Guide.