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

What part are you having trouble with?

Jump to Post

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.