Shiluka's Blog

  LMS   Library Management System for Imaginary University    2nd year Database Project In order to maximize the use of system resources to perform work as efficiently and rapidly as possible the views and indices to be used were confirmed and some of the views were decided to materialize. In the application a user can search a book based on its authors, title and subject as well as ISBN number. Therefore by creating indices on tilte, authors and subjects the database can access relevant entries more efficiently. Since the table book_details is not updated frequently this will not cause for any low performance of the database. book_details create index book_title on book_details(title); create index book_publisher on book_details(publisher); create index book_category on book_details(category); cd_details create index cd_title on cd_details(title); create index cd_publisher on cd_details(publisher); create index cd_category on cd_details(category); borrows create

  LMS   Library Management System for Imaginary University    2nd year Database Project Data Definition Language (DDL) of the database. create table items     (      id                  INT PRIMARY KEY,      borrowed            boolean,      received_as         varchar(50)             );     create table book_details     (      ISBN                varchar(15) PRIMARY KEY,      title               varchar(50) not null,      edition             varchar(15),      publisher           varchar(50),      category            varchar(50),      price               float(7,2)         );         create table books     (      item_id         int PRIMARY KEY,      ISBN            varchar(15) ,         foreign key (item_id) references items(id),      foreign key (ISBN) references book_details(ISBN)         );    create table cd_details     (      ISSN                 varchar(15) PRIMARY KEY,      title                varchar(50) not null,      edition              varchar(15),      publishe

  LMS   Library Management System for Imaginary University    2nd year Database Project There are Four main entities Item : a book or as CD which can be borrow from the library Member : a registered member of the library who will be a student or a staff member Location : the physical location where an item is stored in the library Operator : a library staff member who will interact with members of the library. That is they will add/update data about members, transactions and items in the library Entity Relationship Diagram (ER Diagram) ER diagram There can be many copies of the same item (Book or CD). However since we need to identify each item separately so that each of them are given a unique id which is the 'item_id'. Storing common details of the same copies of items make redundancy, the details of items are decomposed into separate tables named 'book_details' and 'CD_details'. A member can borrow four books (or CDs) at a time and

  LMS   Library Management System for Imaginary University    2nd year Database Project Functional Requirements Administrator Add/delete/update details of a member for the library staff. Add/remove/change privileges of library staff to access the system All functionalities of an operator ( mentioned below ) Operator Add/delete/update book details (location) Issue/accept lent books Issue fine receipts Member Search books (for location, availability, other related books, etc.) Check user history Guest  only allowed to view data about resources available in the library Non Functional Requirements Data validation Data validation is having valid data for a given type of variable. Data must be validated to ensure the consistency of data. Security The security to the data base from unauthorized access is prevented by proper authentication giving access privileges for users. In addition security from SQL injection is prevented at the impleme

  LMS   Library Management System for Imaginary University    2nd year Database Project Database management is a wide area of computer science which is essential in most of the applications in order to store and handle data proper and efficient way. Library management system is one of a most frequently used application of database management systems where there is a chunk of information to store and record daily. Background University of ABC is a imaginary university of about 12000 students and 1000 of staff. The library system of the university facilitates all students, academic and non academic staff by providing access to the library. Anyone of the university can read books or other documents at the library, but in order to borrow them one should register and get the membership. The membership is valid only for a year and that should be updated afterwards. After getting the membership, a member can borrow 4 books at a time and maximum burrowed period is 2 weeks. Users

I am interesting in renewable energy area from my childhood. Sri Lankan government introduced grid solar power system for residential few years ago. I was able to install grid solar power system at my home in 2014  with my uncle's help who has great knowledge about electric systems. Mainly there are two types of Solar Systems i.e off grid and grid tied. DC off grid system rarely use [most electric components are capable only for Alternative Current (AC)]   AC off grid system Inverter converts Direct Current (DC) to Alternative Current (AC). You can use a generator if you want to get power when battery bank is dead. grid system with batteries With a Battery bank you can have current to your home when distribution line power cut. you cant do that without a battery bank. because extra power should be store somewhere (in a battery bank). grid system with batteries I am using this system (without a battery bank). At Day time we are using the

Bingo Deals 2nd year software engineering project Shiluka Raveen Dharmasena Undergraduate Computer Science and Engineering University of Moratuwa Main Window of the Application Live Deals : show the Live Messages from the site Deals Around : show the Deals around your current location Island wide Deals : show all the deals Island wide Deals window  User can choose which kind of category he/she needs. There are 4 types of categories 1. Café Deals 2. Food Deals 3. Movie Theater Deals 4. Shopping Deals   Island wide Deals List Show all the deals from database (Name of the location and the vicinity)   Currently show the default icon of the location Deal Window There are several details about the deal Location Name : which location gives the deal  Telephone number of the location Website of the location Deal of the Location Direction to the location can be viewed by clicking the “Show Directions” Button Show the Place using Goog

Bingo Deals 2nd year software engineering project Shiluka Raveen Dharmasena Undergraduate Computer Science and Engineering University of Moratuwa Deployment View  This is How User receive  Evaluation Test Case Description Status Testing Alert Dialog Manager Display alerts on mobile phone passed Testing wake locker Acquire power services of the mobile phone passed Testing notification manager Allow to notify the mobile phone passed Testing GPS tracker Track the current location of the user passed Testing Connection Detector Detect the network connectivity passed Testing GCM Intent Services Test the Google Cloud Messaging base activities. passed Testing Server Utilities Test Server Base Activities passed Testing SQL Database Activities User details and site details are kept in two databases. passed

Bingo Deals 2nd year software engineering project Shiluka Raveen Dharmasena Undergraduate Computer Science and Engineering University of Moratuwa Use Case View Resister for an account User can sign up for an account from the app. User need to enter email address Receive deals User can receive deals from nearby locations by clicking send deals button in the Bingo application Select whatever user wants to receive from the site There are several types of deals or coupons available such as Hotels, Super markets and Cafes. So the user can select what kind of deals he/she wants from the website Login to the account User can login to their account using username and password Get the nearby locations  User can get the information about nearby locations such as distance, reviews, address, and mobile number from the Bingo application User Application

Bingo Deals 2nd year software engineering project Shiluka Raveen Dharmasena Undergraduate Computer Science and Engineering University of Moratuwa Main objective of this app is to send deal alerts when the locations are discovered. If mobile has GPS, deals can be sent as mails (notification popup). Addition to that it finds user’s current location plotted on a map and displays details of nearby discovered sites such as address, phone number, distance from current location, ratings, reviews etc. Tasks 1. Research into project and the tools available        I. Research about the Google map API Permissions to get from the google api console, Research about JSON parser, Place JSON    parser, DirectionsJSON parsers. Research about google nearbyplaces and google directions api.   II. Research about push notifications & databases at the server GCM (google cloud message) server, SQLite database (inside android os), SQLiteOpenHelper.  III. Research abou

Bingo Deals 2nd year software engineering project Shiluka Raveen Dharmasena Undergraduate Computer science and Engineering University of Moratuwa Why did I want to create this App ? People are always looking for great deals around them wherever they stay or traveling, but still there are no flexible solutions to meet their demands except traditional method such as email marketing, social media ads etc. It is difficult and irritating to check emails for deals around them, but if we can give updates automatically about deals to our smart phones wherever we travel, it is really awesome. Bingo is an innovative smart phone app uses android with GPS technology which helps user to get daily updates such as deals/discounts from hotels, restaurants, cafes, movie theatres, super markets or virtually anything near according to his/her current location. How this is going to work ? First user should register for a user account with his/her email address and