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

Added on - 16 Sep 2019

  • 7

    pages

  • 800

    words

  • 111

    views

  • 0

    downloads

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
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document