5. [HOME INVENTORY DATABASE]. Student Name:. Student ID

Added on - 16 Sep 2019

  • 7

    Pages

  • 800

    Words

  • 226

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 7 pages
[HOME INVENTORYDATABASE]Student Name:Student ID:Course Name:Course ID:Faculty Name:University Name:
1Contents1. Software Tool Description...........................................................................................................23.SQL Section..................................................................................................................................24. Security measures you will put in place for the database............................................................25. Your strategy for testing, collecting feedback and making future updates.................................26. Your strategy for validating effectiveness at meeting the original requirement(s). Identifyspecific metrics you will collect and analyze..................................................................................2
21. Software Tool DescriptionI have used Mysql Query Browser 5.0. In this software it is easy to create new script, can copyone script data to another script, can save as with other name.In this it is easy to edit the script and the queries. This software is user friendly we can do manythings with queries and by keyboard shortcut commands like to delete the databases by ctl +delete or with Mysql query. We can import and export mysql databases using command or withfile menu.3. SQL Sectiona) Create CommandsCREATE DATABASE HOME_INVENTORY;USE HOME_INVENTORY;CREATE TABLE USERS(loginID VARCHAR(30) PRIMARY KEY,pass VARCHAR(50) NOT NULL,userType ENUM('ADMIN','NORMAL'));
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document