logo

HOME INVENTORY DATABASE

   

Added on  2019-09-16

7 Pages800 Words134 Views
 | 
 | 
 | 
[HOME INVENTORYDATABASE]Student Name: Student ID: Course Name: Course ID:Faculty Name: University Name:
HOME INVENTORY DATABASE_1

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
HOME INVENTORY DATABASE_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'));
HOME INVENTORY DATABASE_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Implementation Assignment 2022
|24
|2500
|10

Database Design in DBMS Tutorial: Learn Data Modeling
|17
|1795
|26

Data Modelling & Database Design tasks 2022
|10
|1825
|14

Database Modelling Assignment | Task
|11
|1429
|21

Documentation for MakeUpTest Database
|12
|1628
|412