Create the following table using SQLite database
The basic building block of the system.
Book: Every book will have BookID, BookTitle, Author, ISBN, Publishers.
Employee : Every Employee will have EmployeeID, EmployeeName, FatherName, Designation, Salary
Student: Every student will have Registration, StudentName, DOB, Program, Term
Create table for issue and return base of system requirement

Recommended Answers

All 2 Replies

What part are you having trouble with?

Here's a tutorial on how to create a tutorial in SQLite:

https://www.sqlitetutorial.net/sqlite-create-table/

Based on reading it, it looks like you would want SQL queries similar to:

CREATE TABLE book (
    BookID INTEGER PRIMARY KEY,
    BookTitle TEXT NOT NULL,
    Author TEXT NOT NULL,
    ISBN TEXT NOT NULL,
    Publishers TEXT NOT NULL
);

CREATE TABLE employee (
    EmployeeID ...
);

CREATE TABLE student (
    Registration ...
);
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.