lundi 7 juin 2021

Need someone to create me a small database

I need someone to create an example of this database task so I can study it and make few other databases without help. Thank you in advance!

The task is:

Working with Databases

  • Create a database named "Book_store". The database contains two tables,
    • Name, Genre, Year of Publication, Price, Available Issues
    • and a table Genre - ID, Genre.
  • Your program should have the following functionality:
    • Create the database and tables (with code, not via phpmyadmin)
    • Storing a certain number of books (at least 5 input via HTML form) and at least two different genres;
    • Displaying the complete information for all books in the "Fantasy" genre;
    • Change the price of a specific book at a 10% discount (via HTML form);
    • Display of books having stock greater than 20pcs and sorted by genre (alphabetical order)

Translated with www.DeepL.com/Translator (free version)

Aucun commentaire:

Enregistrer un commentaire