Question: Create a database using PHPMyAdmin and name the database ClothingStore. The database may consist of the following tables: tblUser tblAdmin tblAorder tblClothes or use the

Create a database using PHPMyAdmin and name the database ClothingStore. The database may consist of the following tables: tblUser tblAdmin tblAorder tblClothes or use the ERD tables you created in Part 1. Simplify the design by analysing the relationships among the tables. Ensure that you create the necessary primary keys and foreign keys coding the constraints as dictated by the ERD design. 2. Create a connection to the clothesStore database: Create a text file userData.txt and populate the text file with at least five fictitious entries, e.g., John Doe j.doe@abc.co.za 29ef52e7563626a96cea7f4b4085c124. C. Use the console or phpMyAdmin and load the text file manually into the table. The code that creates the connection must be saved in a f

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!