PromptBase
🤖 GPT
🚀 Introducing the ultimate DATABASE CREATOR PROMPT ! With this prompt, you can easily create and manage custom databases tailored to your specific needs.
💼 Whether you're running a small business, managing a team, or simply need to organize your personal data, you can create a database that's perfectly suited to your unique requirements and which respect The 3NF standard !
HOW USE THIS PROMPT ? ✅
- Write a littre description of what you want 📝
...more
$3.99
After purchasing, you will gain access to the prompt file which you can use with GPT or the app builder. You'll receive 20 free generation credits with this purchase. By purchasing this prompt, you agree to our terms of service.
Over 1 month ago
Prompt Details
Model
Chat - GPT-3.5 (gpt-3.5-turbo)
Token size
167 ($0.00030 / call)
Example input
A library with a collections of book, a collections of borrowers and she keeps track of loan
Example output
DICTIONARY DATA:
Book:
book_id (integer): unique identifier for each book
title (string): title of the book
author (string): name of the author of the book
isbn (string): International Standard Book Number of the book
publication_date (date): date of publication of the book
library_id (integer): unique identifier for the library that owns the book
Borrower:
borrower_id (integer): unique identifier for each borrower
name (string): name of the borrower
email (string): email address of the borrower
Loan:
loan_id (integer): unique identifier for each loan
book_id (integer): foreign key referencing the book borrowed
borrower_id (integer): foreign key referencing the borrower who borrowed the book
start_date (date): date on which the loan started
end_date (date): date on which the loan ended
MLD:
Book (book_id [PK], title, author, isbn, publication_date, library_id [FK])
Borrower (borrower_id [PK], name, email)
Loan (loan_id [PK], book_id [FK], borrower_id [FK], start_date, end_date)
SQL CODE:
CREATE TABLE Book (
book_id INT PRIMARY KEY,
title VARCHAR(255),
author VARCHAR(255),
isbn VARCHAR(255),
publication_date DATE,
library_id INT,
FOREIGN KEY (library_id) REFERENCES Library(library_id)
);
CREATE TABLE Borrower (
borrower_id INT PRIMARY KEY,
name VARCHAR(255),
email VARCHAR(255)
);
CREATE TABLE Loan (
loan_id INT PRIMARY KEY,
book_id INT,
borrower_id INT,
start_date DATE,
end_date DATE,
FOREIGN KEY (book_id) REFERENCES Book(book_id),