Ask a question to Desklib · AI bot
Home Inventory Database: Software Tool Description, SQL Section, Security Measures, Testing and Validation Strategies
Added on -2019-09-16
This article describes the Home Inventory Database, including its software tool description, SQL section, security measures, testing and validation strategies. The SQL section includes create commands, select statements, and data display meeting certain conditions. Security measures include a separate table for user login and password, with user types of admin or normal. The testing and validation strategies involve avoiding anomalies and updating the database to meet new requirements. Metrics for effectiveness include a separate table for item images and unique item IDs.
| 7 pages
| 800 words
| 134 views
Trusted by 2+ million users,
1000+ happy students everyday
[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). Identify specific 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 copy one 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 many things 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 with file 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'));
Found this document preview useful?
You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan