ER Assistant is a data modeling software for creating, editing, and printing an entity relationship diagram. The diagrams can be copied to Microsoft Word. Using ER assistant Instructions Completeness Error Solution Copying an ERD to a Word Document Saving an ERD on Z drive Link for set up: https://umuc.equella.ecollege.com/file/2accfdf7-1316-4935-8a9a-1a031d5d1e6e/1/DBST651.zip/Course%20Content/files/Using%20ER%20Assistant.doc Introduction to Virtual Desktop Virtual desktop is a server-based PC screen delivered to your personal computing device. UMUC virtual desktop is a Windows Server 2008 desktop with all the necessary course software already installed. You may access the Virtual desktop environment through VMware Client. This access method requires downloading the client application to your computer. The client enables fast performance and supports some features, such as keyboard shortcuts, that might not be supported by via browser. However, downloading the client requires administrative rights on the PC. In addition, your firewall configuration should not block the RDP or PCoIP protocols. If you are unable to install the VMware Horizon client or if your firewall restrictions prevent connecting through VMware Horizon client, you may access VDA in a browser. The web interface does not require the software installation. However, there could be some clipboard limitations. Before you may login via VMware Horizon client or via browser, you need to reset your VDA password at the VDA Self-Service Portal. Your user name is the same as your LEO user name. Instructions to Reset VDA Password Instructions to Access Virtual Desktop Access via VMware Horizon client Access via Web Browser System Requirements System Requirements for VMware Client System Requirements for Web Browser Download instructions Instructions to Install VMware client Instructions to Upgrade VMware client N/A Login Instructions Instructions to Login and Log out Instructions to Login and to Log out Copy And Paste between VDA and Local PC You may copy and paste text, screen shots, and images as you normally would. The clipboard can accommodate 1MB of data for copy and paste operations. Youmay not copy and paste files between VDA and local PC. You can copy plain text or formatted text, including any non-ASCII characters. The pasted text will show as plain text. You may copy and paste up to 5,000 characters. You may notcopy and paste graphics and files between VDA and local PC. Copy and Paste (Text only) Miscellaneous Instructions "Could not Resolve the Host Name" Error HTML Access Online Help Software on Virtual Desktop ER Assistant is a data modeling software for creating, editing, and printing an entity relationship diagram. The diagrams can be copied to Microsoft Word. Using ER assistant Instructions Completeness Error Solution Copying an ERD to a Word Document Saving an ERD on Z drive Oracle data modeler is a data modeling is the alternative software for creating, editing, and printing an entity relationship diagram. The diagram can be saved as an image or as a pdf file. Using Oracle SQL Developer Data Modeler Instructions Saving the model Opening the model Saving the model as an image Saving the data model as a PDF file Oracle SQL Developer is a user-friendly interface for connecting to the database and for running the queries and sql scripts. In DBST 651 class, the scripts include: • SQL statements to create tables, sequences, indexes, views, and triggers • SQL statements to insert data into the tables • SQL queries Before you login to Oracle SQL Developer for the first time, you need to reset an initial temporary password changeme Oracle SQL Developer Resetting Initial Temporary Password (need to do this only once before the first login) Oracle SQL Developer Login Instructions (after resetting an initial temporary password) Introduction to Oracle SQL Developer Interface Saving the .sql File Opening the .sql File Showing Line Numbers in Oracle SQL Developer Worksheet You may save your work on Z drive. The files will not be lost at the end of the session. Using Z Drive Instructions Access 2013 Power Point 2013 Excel 2013 Project 2013 Visio 2013 Word 2013 Snipping Tool is a program for capturing full screen or part of the screen. You may paste the captured image into a Word document or you may save the image on a z drive. Click to Learn More about the Tool Use Adobe Reader to open files in pdf format. Click for more information on using Adobe Reader Notepad - Use for opening the text files and .sql files with SQL commands. Web Browsers Google Chrome Mozilla Firefox Internet Explorer Saving Files The work on a Virtual Workstation cannot be saved on a local PC directly if you access via Web Browser. All files need to be saved on a VDA Z drive. You may email the files to yourself, or you may save the files on your Google Drive. To learn more about the Google Drive access, visithttps://apps.google.com/learning-center/ Instructions for Accessing Local PC Files From VDA - only if you use VMware Horizon client. VDA Self Service Portal https://umucpw.aeronomy.net/showLogin.cc If you lost your VDA password, and/or if your VDA account got locked after 5 consecutive unsuccessful login attempts, you may use this VDA Self-Service portal to restore access to your VDA account. Instructions to Reset VDA Password Instructions To Unlock VDA Account VDA Password Change when you have current password **The portal does not support resetting an Oracle password and unlocking Oracle account. Contact the TA for assistance if needed.**