Hi this is my lab assignment of data management and security course just simple 4 tasks just make sure I want all the tasks in exact format as mentioned in document under every question and kindly mention my name ID and email on every solutionsNAME: AHMER NASIRSTUDENT ID:6880101STUDENT EMAIL:
[email protected] may need access to my moodle for any software if you can manage it's fine otherwise I'll give you access to moodle and make sure kindly submit on time I have to submit
- Task 1 -solution1.bmp
- Task 2 -task2.sql
- Task 3 -solution2.rpt
- Task 4 -questions.pdforquestions4.pdf
IN THIS FORMAT I NEED ALL SOLUTIONS
Microsoft Word - laboratory1.docx Diploma of Information Technology Session: Autumn 2021 UOW College Australia DPIT115 Data Management and Security Laboratory 1 Published on 2 March 2021 Scope This laboratory includes the tasks related to the applications and software systems that will be used in DPIT115 Data Management and Security in Spring session 2020. The outcomes of the laboratory are due by Sunday 14 March 2021, 11.55 PM Please read the information listed below very carefully. This laboratory contributes to 5% of the total evaluation in a subject DPIT115. This laboratory work consists of 4 tasks, and the specification of each task starts from a new page. The submission procedure is detailed at the end of the specification. A submission in an incorrect file format, filename format, or as a compressed file (zipped, gzipped, rared, tared, 7-zipped, lhzed, … etc) will not be evaluated. A submission marked by Moodle as Late is treated as a late submission no matter how many seconds it is late. All files left on Moodle in a state "Draft(not submitted)" will not be evaluated. An implementation that does not compile or run due to one or more syntactical errors scores no marks. It is expected that you will solve all tasks individually without any cooperation with the other students. If it is suspected that you have received assistance from another person to complete the tasks, the matter will be investigated as an alleged breach of the UOW College Academic Integrity and Student Conduct Policy, in accordance with the Procedure for Managing Alleged Student Misconduct. As part of this investigation, you may be required to undergo an oral examination to verify your understanding of the assessment content. If you have any doubts, questions, etc., please consult your lecturer or tutor during lab classes or office hours. Software required for this subject The software required for this subject can be download via the Moodle site and installed on your personal computer. The software will be pre-installed on your university computer laboratory. Consult your tutor during lab classes for further details. You can install Microsoft Office 365 Applications for Mac and PC on your personal computer. Login to https://portal.office.com/ with your UOW email address to download. Download UMLet 14.3 from the link on Moodle and unzip to a folder called Programming Apps on your Desktop. You will use UMLet 14.3 to draw database schema in this subject. This subject requires you to use a Virtual Server to develop and administer MySQL databases. To install on your personal computer, Download VirtualBox and Extension Pack from https://www.virtualbox.org/wiki/Downloads The Virtual Machine is a large file (2.72 GB) only download if you do not already have the file. Note that the virtual machine can be downloaded from computer labs on campus if you have limited bandwidth and downloads. Consult your tutor during lab classes for further details on how to import the Virtual Machine into Virtual Box. Further details are published on Moodle and CSIT115 Data Management and Security, "How to ... ?" Cookbook. Tasks Task 1 (1 mark) The objective of this task is to show you how to create a conceptual database schema with UMLet 14.3. Perform the following steps. (1) Start and connect to your Windows system. (2) UMLet 14.3 is a tool for drawing UML diagrams. To start UMLet 14.3 use UMLet shortcut available in a folder Programming Apps located on Desktop. The shortcut has an icon that consists of a red circle crossed with a horizontal red bar with a white text UMLet. (3) When UMLet is started, navigate to the right upper corner of UMLet window and pick a palette CSIT115-815Palette. Do not use any other palettes. (4) Use UMLet application to draw a diagram given below. It is explained in the Cookbook, Recipe 2.1, Steps 1 and 2 "How to create very simple conceptual schemas with UMLet?" how to use UMLet to create class diagrams. For a moment, do not worry about the meanings of a diagram created. It will be explained to you later on during the lecture classes. (5) When ready, add one more attribute to a class SUBJECT and one more association between the classes STUDENT and SUBJECT. The new attribute and the new association are up to you. (5) Add your name, student number and date to your diagram. You can use a box that is not connected or part of your diagram to show this. (6) Use an option File->Save to save your diagram in a file solution1.uxf. Do not delete a file solution1.uxf. (7) Use an option File->Export as… to export your diagram into a file solution1.bmp in BMP format. Do not delete an exported file. You will submit it as one of the deliverables from your laboratory work. Deliverables A file solution1.bmp that contains a diagram given above extended with an attribute and with an association. A submission of a file solution1.uxf is not expected, and it scores no marks. Submission of a file with a different name and/or different extension and/or different type scores no marks as well. It is strongly recommended to check the contents of a file solution1.bmp BEFORE the submission and not after the submission. Task 2 (1 mark) The objective of this task is to learn how to use SQL Workbench a Graphical User Interface (GUI) to the MySQL database. Perform the following steps. (1) Start and connect to your Windows 10 system. (2) To start VirtualBox, use the shortcut to the Oracle VM Virtual Box application. This is explained in Cookbook, Recipe 1.1, Step 1 "How to start VirtualBox ?" how to start VirtualBox. (3) When VirtualBox is started, import an appliance Ubuntu18.04-64bits- MySQL8.0.21-31-AUG-2020 located in the location specified by your tutor. The process is explained in Cookbook, Recipe 1.1 Step 2 "How to import an appliance to VirtualBox ?" how to import an appliance. (4) It is strongly recommended to copy a file Ubuntu18.04-64bits- MySQL8.0.21-31-AUG-2020 to your USB drive if working in the university lab. This will allow you to import it to VirtualBox installed on your system at home. Using this approach, the same software as installed in a laboratory class can be used at home. If only using your personal computer, use your local hard disk to store the file. (5) Power on a virtual machine Ubuntu18.04-64bits-MySQL8.0.21-31-AUG- 2020. It is explained in Cookbook, Recipe 1.1 Step 4 "How to power on a virtual machine ?" how to power on a virtual machine. (6) When the Ubuntu 18.04 operating system displays an orange box with a name CSIT115 user press Enter key and then type csit115 into a Password field. Then, patiently wait until an operating system displays a column of icons on the left-hand side of a screen. (7) To start SQL MySQL Workbench GUI left-click at the 6th icon from the top with the icon with a silhouette of a white dolphin. (8) Next, to open the csit115 connection, left-click at an icon associated with the csit115 connection within MySQL Connections (localhost:3306). (9) Select Connect, type csit115 into a field Password, and click at OK button. (10) MySQL Workbench opens in a new sub-window titled Query1. Type use csit115; command into the Query1 sub-window. Move a mouse cursor to any location within use command and left-click the second yellow lightning icon to process the command; this will choose csit115 to be the default database. The results from processing the script are displayed below in the Action Output sub-window. (11) Type the following lines of code with the SQL CREATE TABLE statement into the panel Query1 panel. CREATE TABLE FIRST_NAME(name VARCHAR(20) NOT NULL, CONSTRAINT FN_PK PRIMARY KEY(name)); SQL statement listed above creates a single column relational table FIRST_NAME. Move the mouse cursor to any location within CREATE TABLE statement and left- click the second yellow lightning icon to process the statement. The results from processing will be displayed below in Action Output sub- window. (12) Save the text typed in the previous step as a SQL script file task2.sql. To do this, use the blue floppy disk icon to save the file. Do not delete a file task2.sql. You will submit it as one of the deliverables from your laboratory work. (13) Type into the following INSERT statement of SQL into the task2 sub-window. INSERT INTO FIRST_NAME ('James'); (14) To process the statement above, left-click the second yellow lightning icon in the icon. This time you should get an error message in the bottom sub-window. (15) The problem is that the keyword VALUES is missing between FIRST_NAME and left bracket (. Add the keyword and process the statement again. I hope you do not get any errors that this time :). (16) Add and process the following SELECT statement to list the contents of a relational table