1. Requirement gatering. First i understood the purpose of my system like what my system need to do,operations and rules
2. Conceptual Design. Create a rough model using Entity-Relationship (ER) diagrams.identify key entities and define attributes
3. Logical Design. Translate the ER model into a relational schema.Define tables and columns.Assign primary keys and also find foreign key relationships.
4. Did Normalization
5. Physical design. Choose Database management system SQLITE for my domain and create a database called LIB in SQLITESTUDIO
6. create table(schema) inside my database LIB .write SQL query to create table and test and debug it.
7. than created connection with mydatabase in DBSCHEMA create ER diagram in it .