World's most popular travel blog for travel bloggers.

Key Differences Between Strong Entity and Weak Entity

  1. The basic difference between strong entity and a weak entity is that the strong entity has a primary key whereas, a weak entity has the partial key which acts as a discriminator between the entities of a weak entity set.
  2. A weak entity always depends on the strong entity for its existence whereas, a strong entity is independent of any other entity’s existence.
  3. A strong entity is denoted with a single rectangle and a weak entity is denoted with a double rectangle.
  4. The relationship between two strong entities is denoted with single diamond whereas, a relationship between a weak and a strong entity is denoted with double diamond called Identifying Relationship.
  5. The strong entity may or may not show the total participation in its relations, but the weak entity always shows total participation in the identifying relationship which is denoted by the double line.
Design ER n Table accordingly

MVD

Question:

The following are the relational schemes of Employee, Project and Assigned-to Employee (Emp#, Emp_name, Profession), Project (Proj#, Proj_name, Chief_Architect), Assigned-to (Proj#, Emp#). 

Create appropriate samples of each relation according to the question. Write the following queries in SQL.
(i)  Get Emp# of employees working on Project numbered MCS-043.
(ii) Get details of employees working on database projects.
(iii) Finally create an optimal query tree for each query.




Given the following semi-structure data in XML, create the DTD 
(Document Type Declaration) for it 

<document>
    <student>
      <NAME>
      <Address>
    </student>
   <student>
      <NAME>
      <Address>
   </student>
</document>

What are the different options available for storing XML data?


Introduction

  • Project Name: - Medical Store Management 
  • This project is used mainly for medical stores to maintain the details of medical store such as stock and account. 
  • This medical shop management software is so designed as to ease the work load of medical shop professionals. The main feature includes inventory and stock control, accounting, client management

Scope & Objectives 

As this is generic software it can be used by a wide variety of outlets (Retailers) to automate the process of manually maintaining the records related to the subject of maintaining the stock and cash flows. 
This project is basically updating the manual chemist inventory System To Automated inventory system, So that organization can manage their record in efficient and organized form.

This software helps you to track all the products of medical shop moreover it’s a medical shop accounting software. Flexible and adaptive software suited to medical shops or stores or pharmacies of any size. 
 Project Characteristics: 
 Customer management 
 Transition management 
 Sales management 
 Reporting

 The main goal of the application is to maintain the records of purchase, Sales and stock details with cash transaction maintenance. 
 Medical Store Management software is very needy for Medical Store . This software help them maintain day to day transactions in computer.

Background & Specification

A medical store needs to maintain its inventory of medicines and other products using a 
computerized system. It is planning to create a network of computers which should be 
placed at various sales and cash counters. It also proposes to have a centralized 
workstation for the database and system administrators. Customer orders are accepted 
at the sales counters which in turn produces a medicine collection challan. The challan 
includes the order number, name of medicine, batch number, date of expiry, shelf 
number where it is kept and quantity ordered. One order may contain more than one 
medicine. As per challan, medicines are put in a basket by a person, who passes it to 
billing assistant. Billing assistant checks the medicine is as per the challan, any 
shortcoming is either corrected or reported to customer. On receiving conformation 
from the customer the bill is generated. The cash counter collects the money as per the 
bill and dispenses the medicine to the customer.

Project Features 

 There Will be two user Accessing System System 
 Manager : Who will act As Administrator 
 Other Staff: Who Will accessing the System 
 User The Features for manager are 
       Add ,delete update any product 
 Manage store i-e(put price,make salaries,Calculate Revenue )

User Classes and Characteristics 

 User Of project include customers and staff 
 Customer can be Member or visitor who are accessing this system. 
 Staff Which act as administrator and controlling overall system 
 User Should IT literate And know to use computer 
 Cashier Should Know Data entry & Typing 
 Manager should have knowledge of Internet & Browsing 

Operating environment 

 This project will be operating in windows environment.Also compatible with internet explorer. 
 The only requirement For using this project is having machine. Design and implemention constraints 
 This project is developed using java.on the back hand for database we are using Sql server. The product is Accomplished With the login facility for user. User Documentation 
 This project will include a user manual. The user manual include Complete overview of the producst,Configuration of the Tool used (Sql Sever or other), technical details, backup procedures and Contact Information which will include email address and Ph# .

Hardware Requirements 

 Processor : 1.6 Ghz and above
 RAM : 1GB RAM 
 Monitor : 1 5”Colour Monitor 
 Processor Speed : 1.7 GHZ 
 Hard disk : 10GB HDD 
 CD Drive : 52- X CD ROM 
 Keyboard : Mercury 110 Keys 
 Mouse : Logitech Mouse

System Features Description & priorirty 

 Proposed Database is intended to store, retrieve, update, andmanipulate information related to Chemist which include 
 Order Processing & taking 
 Staff information 
 Customer Bill Detail 
 Product Details 
 Calculation of Revenue
 Searching of product 
 Remainder About Products expiry,Shaortage 
 Generate Reports

Functional Requirements 

 The software must allow input of products data from Administrator& secured access at , and from the data streaming real-time monitoring equipment 
 The project must request username and password for access to data, only after authentication will allow access to the system. 
 The project must require high levels of error correction and input validation. 
 The project must allow browsing by the Director&Staff of Cms To Acces And update information products & Customers ,vendors. 
 The project must identify the Products & Customer by a unique numeric identifier derived from a function performed on the Customer’s birth date or product Id;

Safety Requirements 

 The Database may get crashed or damaged due to some viruses or operating system requirements.Therefore Its is mandatory to have backup for your data.Ups/inverter facility should be there in case of power failure. 
 Security Requirements 
 System will use secure Database 
 Staff can just see the products & mark their attendance .They Cannot edit or,modify anything except their personal information. 
 Proper user Authentication Will be provided. 
 There should be separate account for Admin &user. So that no one else can access the database except Admin.

User requirements 

 The User Of system are Staff ,Managers and customer of the store.
 The members share assumed to have basic knowledge of computer & internet browsing While administrator of system should have more knowledge so he/she can resolve small problems and perform information’s.
 The user manual ,installation guide and other related material should be sufficient to educate the user how to use and maintain the system.


DFD 0 Level
DFD 1 level
DFD Level 1



Download complete pdf for reference DFD, ERD and Data Dicionary
Click Here

Type of ExpensesWithout SoftwareWith Software
Employee  6 3
 -- Cost (per year)5,76,0002,88,000
Software Exp.(One time)02,00,000
Medicine Expiry
(Per Year)
250000-1000
Customer Return
(No Stock)
 25000 0-1000
Management
Maintenance
800020000
Purchase Order,
Gov. Reports,
Stock Analysis
2 hour daily
730hrs/year
= 36500INR
@ 50INR/hr
5 min
= 29.9hrs/yr
= 1460INR
@ 50INR/hr
List of Customers (Value)0(-10000)
Total(First Year)6,70,500/year501460/year

In terms of : Medical store management system

This project is used mainly for medical stores to maintain the details of medical store such as stock and account.

This medical shop management software is so designed as to ease the work load of medical shop professionals.

The main feature includes inventory and stock control, accounting, customer management.

> Less staff
> Easy Payments
> Less Expired Products
> Autmoatic Stock Re-Order level, no need see all the shelf for the medicine stock.
> One click report of expiring soon medicine, minimum stock

There is different way to look for the system costs.


  1. Hardware needs in shop: Facilitate computer, printer and related equipment to shop (~ 1.2 lac)
  2. Software cost: 
    1. Analysis Cost
    2. Designing Cost 
    3. Developing Cost
    4. Testing Cost
    5. Installing and maintenance