database management case study

Case Studies Examples Scenarios Database System DBMS

Most of the time you see the case studies and scenario-based questions in the Database System (DBMS) paper. Keeping in view, I am sharing with you some of the case study base questions of the database course.

Examples of Case Studies and Scenarios questions from DBMS

• Examples of Case Studies and scenarios from the Database System.
• How you can make a database from the scenario mentioned below.
• How you can normalize the database tables from the case studies mentioned below.
• How to draw the Entity-relationship diagram from the given case study.
• How to draw the Data flow diagram from the case studies mentioned below.
• What database model is suitable for the case studies mentioned below.
• What kind of database users are suitable for the given case study.
• What kind of database redundancies and inconsistencies are possible in the given scenario.
• How You can write SQL Queries on the tables of the mentioned case study.
• Find the possible database keys from the tables of these case studies.
• Suggest the relationships among the tables of the given scenarios.

Vehicle information dissemination system for Cloud  Android Project for BCS BSIT MCS BSSE

Gym and Fitness Management System Project IN C# for BCS BSIT MCS BSSE

HR Management System Project in C# and VB.NET for BCS BSIT MCS BSSE

Employees Attendance System via Fingerprint  in C# and VB.NET for BCS BSIT MCS BSSE

Pharmacy Record Management System Project in PHP, ASP or C#.NET

Car information System using Android and Arduino final year Project for BSCS BSIT MCS BSSE

Agile File Master App final year project for BSCS BSIT MCS BSSE

Android Messenger App final year project for BSCS BSIT MCS BSSE

Android Call Recorder App final year project for BSCS BSIT MCS BSSE

Music Listening App final year project for BSCS BSIT MCS BSSE

Like mind matches Android application – Final year project for MCS

Financial Helper Using QR/Barcode Scanner Android Final year project for MCS BSCS BSSE

My Grocery List Mobile Application Project in  Android

If you are still in reading the more case studies, then you can read 100+ case studies .

Related Posts:

• Case Studies Examples Scenarios OOP
• History of Database System (DBMS)
• Database Management System Architecture MCQs in DBMS
• Leadership Case Studies MCQs
• Ethical Dilemmas and Case Studies MCQs
• DBMS components and functions MCQs in DBMS

You must be logged in to post a comment.

Real-world Database Integration Case Studies: Success Stories, Benefits, and Outcomes

In today's fast-paced business world, staying ahead of the competition requires efficient and accurate data management. Real-world database integration case studies offer valuable insights into the benefits and outcomes of integrating databases and systems. These success stories showcase how businesses have transformed their operations, achieving increased efficiency, improved data accuracy , enhanced decision-making, better customer experiences, and significant cost savings . In this blog post, we delve into various case studies that highlight the key benefits and outcomes of successful database integration projects. Whether you're a business owner or a data enthusiast, these real-world examples will inspire you to harness the power of database integration for your own organization's success.

Increased efficiency and productivity

Case study: integration of customer data across multiple platforms.

In today's digital age, businesses are collecting vast amounts of customer data from various sources such as sales systems, marketing platforms, and customer support software. However, without proper integration of this data, it can be challenging to gain a comprehensive view of customers and their interactions with the company. This is where database integration plays a crucial role.

One success story in database integration involves the integration of customer data across multiple platforms. By integrating data from sales, marketing, and customer support systems into a centralized database, companies can eliminate manual data entry and reduce errors that often occur when transferring information between different systems. This automation of processes not only saves time but also improves operational efficiency .

For example, imagine a scenario where a customer places an order through the company's website. With integrated databases, this order information can be automatically synced with the sales system, updating inventory levels and triggering fulfillment processes. This eliminates the need for manual intervention and reduces the risk of errors or delays in processing orders.

Case study: Streamlining inventory management through database integration

Another real-world case study showcasing the benefits of database integration revolves around streamlining inventory management . Inventory management is a critical aspect of any business that deals with physical products. Without accurate and up-to-date information about inventory levels, companies may face stockouts or overstock situations that can lead to lost sales or increased carrying costs.

By integrating inventory data with sales and procurement systems, businesses can achieve real-time visibility into their inventory levels. This means that whenever a sale is made or new stock is received, the inventory database is automatically updated across all relevant systems. As a result, companies can make more informed decisions about purchasing and fulfillment based on accurate and timely information.

Furthermore, database integration enables improved demand forecasting by providing access to historical sales data alongside current inventory levels. This allows businesses to identify trends and patterns in consumer behavior and adjust their production or procurement strategies accordingly. By avoiding stockouts and overstock situations, companies can optimize their inventory levels, reduce costs, and improve customer satisfaction.

Tapdata: Real-time data capture & sync

When it comes to database integration solutions, Tapdata is an industry leader that offers a comprehensive set of features to enhance efficiency and productivity. With Tapdata's real-time data capture and sync capabilities, businesses can ensure that their databases are always up-to-date with the latest information from various sources.

One key advantage of using Tapdata is its guaranteed data freshness. By capturing data in real-time and syncing it across systems instantaneously, companies can rely on accurate and timely information for decision-making processes. This eliminates the need for manual data updates or batch processing, saving time and reducing the risk of outdated or inconsistent data.

Tapdata also provides a flexible and adaptive schema that allows businesses to easily consolidate data from multiple sources. Whether it's sales data from an e-commerce platform, marketing analytics from a CRM system, or customer feedback from social media channels, Tapdata can seamlessly integrate all these datasets into a unified database structure. This ensures that businesses have a holistic view of their operations without the need for complex data transformations or manual mapping.

In addition to its powerful integration capabilities, Tapdata offers a low code/no code pipeline development and transformation environment. This means that even non-technical users can design and deploy data pipelines without relying on IT resources. With its intuitive user interface and drag-and-drop functionality, Tapdata empowers business users to take control of their data integration processes.

Furthermore, Tapdata provides comprehensive data validation and monitoring features to ensure the accuracy and quality of integrated datasets. Businesses can set up automated checks and alerts to identify any anomalies or inconsistencies in the data flow. This proactive approach helps maintain data integrity throughout the integration process.

Enhanced data accuracy and quality

Case study: enhancing marketing campaigns with integrated customer insights.

In today's digital age, businesses have access to vast amounts of customer data from various sources such as CRM systems and website analytics. However, the challenge lies in effectively utilizing this data to enhance marketing campaigns and drive better results. This is where database integration plays a crucial role in improving data accuracy and quality.

By integrating customer data from different sources, businesses can create comprehensive customer profiles that provide valuable insights into their preferences, behaviors, and purchasing patterns. For example, by combining CRM data with website analytics, businesses can gain a deeper understanding of how customers interact with their brand across different touchpoints.

With this integrated customer insight, businesses can then create targeted marketing campaigns that are tailored to specific segments or individual customers. By personalizing the messaging and offers based on comprehensive customer profiles, businesses can significantly improve campaign effectiveness and achieve higher return on investment (ROI).

For instance, let's consider a case study of an e-commerce company that successfully enhanced its marketing campaigns through integrated customer insights . By integrating data from their CRM system, which contained information about past purchases and customer demographics, with website analytics data that tracked user behavior on their online store, they were able to gain a holistic view of each customer.

Using this integrated data, the company was able to identify patterns and trends in customer behavior. They discovered that certain products were more popular among specific demographic groups and that customers who made repeat purchases had distinct preferences compared to first-time buyers.

Armed with these insights, the company created targeted marketing campaigns for different segments of their customer base. They personalized email newsletters with product recommendations based on past purchases and sent exclusive offers to loyal customers. As a result of these efforts, they saw a significant increase in click-through rates and conversion rates for their email campaigns.

This case study highlights how integrating customer insights from multiple sources can lead to improved data accuracy and quality. By breaking down silos and bringing together data from different systems, businesses can gain a more comprehensive understanding of their customers and make informed marketing decisions.

Case study: Improving decision-making through real-time data integration

In today's fast-paced business environment, timely access to accurate and up-to-date information is crucial for making informed decisions. However, many businesses struggle with data scattered across different systems, leading to delays in decision-making and missed opportunities. Database integration can address this challenge by enabling real-time data integration from various sources.

Consider the case of a manufacturing company that successfully improved its decision-making process through real-time data integration. The company had multiple systems in place for sales, finance, and operations, each generating valuable data. However, these systems operated independently, resulting in delays in accessing critical information.

By implementing a database integration solution, the company was able to bring together real-time data from all these systems into a centralized platform. This allowed them to have a holistic view of their business operations at any given time. For example, they could monitor sales performance in real-time, track inventory levels accurately, and analyze financial metrics without manual intervention.

With this timely access to accurate information, the company's decision-makers were empowered to make informed choices quickly. They could identify trends and patterns as they emerged and respond promptly to market changes. This improved agility enabled them to adjust production schedules based on demand fluctuations and optimize inventory levels to avoid stockouts or excess inventory.

Furthermore, the integrated data provided valuable insights into the company's overall performance. Decision-makers could easily identify areas of improvement or inefficiencies by analyzing key performance indicators (KPIs) across different departments. This led to targeted initiatives for process optimization and cost reduction.

Improved data accessibility and insights

Case study: optimizing supply chain management through database integration.

In today's fast-paced business environment, supply chain management plays a crucial role in the success of any organization. The ability to seamlessly integrate data from suppliers, warehouses, and transportation systems is essential for achieving end-to-end visibility and improving coordination. This case study explores how a company optimized its supply chain management through effective database integration, resulting in improved data accessibility and valuable insights.

Integration of supply chain data from suppliers, warehouses, and transportation systems

The first step in optimizing the supply chain management process was to integrate data from various sources such as suppliers, warehouses, and transportation systems. By leveraging advanced database integration techniques, the company was able to establish seamless connectivity between these disparate systems. This integration allowed for real-time data synchronization and eliminated the need for manual data entry or reconciliation.

End-to-end visibility of the supply chain and improved coordination

With the successful integration of supply chain data, the company gained complete visibility into its entire supply chain network. This end-to-end visibility enabled them to track inventory levels, monitor order status, and identify potential bottlenecks or delays in the system. By having access to accurate and up-to-date information at all times, they were able to make informed decisions and take proactive measures to address any issues that arose.

Furthermore, this enhanced visibility also facilitated better coordination among different stakeholders involved in the supply chain. Suppliers could now align their production schedules with demand forecasts more effectively. Warehouses could optimize their inventory levels based on real-time sales data. Transportation systems could plan routes more efficiently by considering factors like traffic conditions or weather forecasts. As a result, the entire supply chain became more streamlined and responsive.

Reduced lead times and optimized inventory levels

One of the significant benefits of integrating supply chain data was the reduction in lead times throughout the process. With real-time access to information about product availability, order status updates, and delivery schedules, the company could expedite order processing and minimize delays. This not only improved customer satisfaction but also allowed them to fulfill orders more quickly, gaining a competitive edge in the market.

Moreover, by having accurate and timely data on inventory levels, the company was able to optimize its stock management practices. They could identify slow-moving or obsolete items and take appropriate actions such as liquidation or promotions to clear excess inventory. On the other hand, they could also identify high-demand products and ensure sufficient stock levels to meet customer demands. This optimization of inventory levels resulted in cost savings and reduced carrying costs.

Actionable insights for informed decision-making

The integration of supply chain data provided the company with valuable insights that were previously inaccessible. By analyzing this integrated data, they could identify trends, patterns, and correlations that helped them make informed decisions. For example, they could identify which suppliers consistently delivered high-quality products on time and establish stronger partnerships with them. They could also analyze customer buying behavior to anticipate future demand and adjust production or procurement accordingly.

Furthermore, these actionable insights enabled the company to implement continuous improvement initiatives throughout their supply chain network. By identifying areas of inefficiency or bottlenecks through data analysis, they could implement process improvements or invest in technology solutions that addressed these issues directly. This iterative approach to supply chain management led to increased efficiency, reduced costs, and enhanced overall performance.

Enhanced customer experience

In today's digital age, providing an enhanced customer experience has become a top priority for businesses. By integrating customer data across multiple platforms, companies can gain a 360-degree view of their customers and deliver personalized interactions that cater to their unique needs and preferences. Let's explore a case study that highlights the benefits of such integration.

360-degree view of customers and personalized interactions

One company that successfully integrated its customer data across various platforms is XYZ Corporation, a leading e-commerce retailer. Prior to implementing this integration, XYZ Corporation faced challenges in understanding their customers' behavior and preferences due to fragmented data sources. They had separate databases for online purchases, in-store transactions, and customer support interactions.

By integrating these disparate data sources into a centralized database, XYZ Corporation was able to create a comprehensive profile for each customer. This 360-degree view allowed them to gain valuable insights into their customers' purchase history, browsing patterns, and communication preferences.

With this holistic understanding of their customers, XYZ Corporation was able to deliver personalized interactions at every touchpoint. For example, when a customer visited their website, they would be greeted with tailored product recommendations based on their previous purchases or browsing history. This level of personalization not only increased the likelihood of conversion but also improved overall customer satisfaction.

Targeted marketing campaigns based on comprehensive customer profiles

Another significant benefit of integrating customer data across multiple platforms is the ability to run targeted marketing campaigns. With access to comprehensive customer profiles, businesses can segment their audience based on various criteria such as demographics, purchase behavior, or engagement levels.

XYZ Corporation leveraged this capability by creating highly targeted email marketing campaigns. They sent personalized offers and promotions to specific segments of their customer base who were most likely to be interested in those products or services. As a result, they experienced higher open rates, click-through rates, and ultimately increased sales.

Faster issue resolution and improved customer satisfaction

Integrating customer data across multiple platforms also enables faster issue resolution and improved customer satisfaction. When a customer contacts XYZ Corporation's customer support team, the representative can quickly access the customer's complete history, including previous purchases, interactions, and any ongoing issues.

This comprehensive view allows the representative to provide a more personalized and efficient resolution to the customer's problem. They can address the issue promptly without requiring the customer to repeat information or go through unnecessary steps. This streamlined process not only saves time for both parties but also enhances overall customer satisfaction.

To read this content please select one of the options below:

Please note you do not have access to teaching notes, the welmed database management system: a case study in system design and applications.

Library Hi Tech

ISSN : 0737-8831

Article publication date: 1 March 1989

The long‐term goal for integrated information management at the Johns Hopkins Medical Institutions is the creation of a knowledge management environment—a network of databases that an individual would tap as one would one's own memory. An important library component in this emerging environment is WELMED, a general purpose bibliographic database management system that permits the library to distribute its databases and related services to its users through common, customizable interfaces. The characteristics and components of the WELMED system are detailed.

Moore, G. (1989), "The WELMED Database Management System: A Case Study in System Design and Applications", Library Hi Tech , Vol. 7 No. 3, pp. 71-80. https://doi.org/10.1108/eb047767

Copyright © 1989, MCB UP Limited

Related articles

All feedback is valuable.

Please share your general feedback

Report an issue or find answers to frequently asked questions

Contact Customer Support

The GraphRAG Manifesto: Unlock Better GenAI Results With Knowledge Graphs | Read Now

• Neo4j Graph Database Self-managed, deploy anywhere
• Neo4j AuraDB Fully-managed graph database as a service
• Neo4j Graph Data Science Graph analytics and modeling platform
• Deployment Center Get started. Download, integrate, and deploy.
• GRAPH TOOLS
• Neo4j Developer Tools Tools to make graph application development easier
• Neo4j Workspace Import, explore, and query Neo4j
• Neo4j Bloom Easy graph visualization and exploration
• Cypher Query Language Declarative graph query language, created by Neo4j
• Neo4j GraphQL Library Low-code, open-source API library
• Generative AI Back your LLMs with a knowledge graph for better business AI
• Industries and Use Cases Fraud detection, knowledge graphs, financial services, and more
• Case Studies Customer success stories across industries
• Customers Companies, governments, and NGOs using Neo4j
• Developer Center Best practices, guides, tutorials, and downloads
• Developer Blog Deep dives into more technical Neo4j topics
• Community A global forum for online discussion
• DATA SCIENTISTS
• Graph Data Science Home Learn what Neo4j offers for data science
• Get Started With Graph Data Science Download or get started in Sandbox today
• Data Science Community A global forum for data-driven professionals
• Resource Library White papers, data sheets, and more
• Executive Insights Get to know Graph Technology
• Neo4j Blog Daily reads on general Neo4j topics
• FEATURED EVENTS
• GraphSummit Touring 20+ cities globally. Join us for free and hear from data and business trailblazers.
• Connections Free, online conference every quarter focusing on new themes every time
• QUICK LINKS
• Find a Partner
• Become a Partner
• Solution Partners
• OEM Partners
• Technology Partners
• Partner Portal Login
• Awards and Honors
• Graphs4Good

Neo4j Graph Database

Intro to the advantages of graph databases

Neo4j AuraDB

Fully-managed graph database as a service

Neo4j Graph Data Science

Graph Analytics and modeling platforms

Deployment Center

Get started. Download, integrate, and deploy.

• Neo4j Data Connectors Download Apache Kafka, Apache Spark, and BI tools

Generative AI

Back your LLMs with a Knowledge Graph for better business AI

Industries & Use Cases

Fraud detection, knowledge graphs, financial services, and more

All Use Cases

Developer Center

Best practices, guides, tutorials, and downloads

GraphAcademy

Free online courses and certifications. Join the 100K+ Neo4j experts.

Hear directly from data and business trailblazers

Touring 20+ cities globally | Free

Join our online conference. New themes every time.

Virtual | Every Quarter | Free

• Get Started Free

Warning: JavaScript is disabled on your browser. Parts of Neo4j.com will not work properly.

Graph database case studies.

IBM Manta Data Lineage

Enhancing Data Trust & Transparency: Governance and Migration with IBM Manta Data Lineage and Neo4j

Data Lineage

BNP Paribas Personal Finance

BNP Paribas Personal Finance Reduces Fraud by 20%

Fraud Detection

ICIJ Empowers Investigative Journalists with Neo4j Graph Technology

Data² Builds Leading GenAI Analytics Platform With Neo4j

BT Group Keeps Customers Connected with Lightning-Fast Inventory Management

Digital Twin

Intuit Safeguards its Network Infrastructure and the Data of 100 Million Customers with Neo4j

Knowledge Graph

Sopra Steria

Real-Time Telecom Network Resiliency Relies on a Graph-Based Digital Twin

Dun & Bradstreet

Dun & Bradstreet Delivers Complex Company Ownership Checks in Milliseconds vs. Days

Top 10 Carmaker

Top 10 Carmaker Automates Compliance to Focus on Innovation

enxchange Transforms the Energy Sector With Graph-Based Digital Twins

Försäkringskassan

Försäkringskassan Deploys Neo4j to Automate Benefits Payments, Prevent Fraud, and Improve Life for Swedish Citizens

SITA Quickly Finds and Returns Lost Items to Airline Passengers With Real-Time Tracking

Track and Trace

Neo4j Keeps Millions of Remote Workers on Citrix Safe, Productive, and Secure

Neo4j for the Enterprise

Transport for London

Transport For London Aims to Cut Congestion by 10% and $750 Million a Year With a Digital Twin Powered by Neo4j

Elsevier Makes Science Research Accessible in Milliseconds with Neo4j

Graph-Based Search

Basecamp Research

Novo Nordisk

Novo Nordisk: Leveraging the Graph for Clinical Trials and Standards

CSX: Building a Digital Twin of the Largest Railroad in the Eastern U.S. with Neo4j

Boosting Supply Chain Insight with Neo4j

Supplier Intelligence

The Doctor Is In: FSMB Creates Recommendation Engine to Streamline Medical Licensure

Real-Time Recommendation Engine

Getting to Mars Faster with a Knowledge Graph

Content Management

Full Steam Ahead: OrbitMI’s AI Maritime Routing Engine

AI / Machine Learning

Driving Faster Cash Flow Management with Neo4j

Financial Services

Creating a Modern Solution to Finding What’s Lost with Neo4j

Murrelektronik

Many Processes, One Single Source of Truth

Bill of Materials

TODO1 Increases Fraud Detection Rates by 200 Percent with Neo4j

Worldline Revolutionizes Train Travel with Neo4j AuraDB

Travel and Hospitality

Orita Powers Customer 360 with AuraDS Resulting in a 500x Increase in Speed

Entity Resolution

COVID-19 Contact Tracing with Neo4j

Neo4j Drives Recommendations & Website Optimization

U.S. Health Insurer

Driving Preventive Care and Patient Journey Visibility

Patient Journey

Department for Education UK

Cloud-Based Graph Technology Drives Efficiencies

Zurich Insurance Switzerland

Faster Fraud Investigations with Neo4j

E-Health Company Creates a Knowledge Graph Solution to Help Patients with Chronic Pain

Tourism Media

Tourism Media Automates Travel Content Generation with Neo4j AuraDB to Get an 8x Increase in Productivity

Modern Banking Products Fueled by a User-Centric Approach

Japanese Auto Manufacturer

Manufacturer Reduces Time to Market with an Enterprise Knowledge Graph for Unified Testing Data

Manufacturing and Supply Chain

Boston Scientific

Graph Data Science Streamlines Complex Medical Supply Chain Analysis

Custom Medical Equipment Manufacturer

Detailed Visibility into Complex Workflows

NewYork–Presbyterian Hospital

NYP Advances Analysis to Track Infections with Neo4j

The World’s Airlines Rely on Graphs to Offer Better Ticket Prices and Travel Options for Customers

Transportation

Graph Technology Powers Cybersecurity Situational Awareness That’s More Scalable, Flexible & Comprehensive

Cybersecurity

Machine Learning and Graph Technology Accelerate Medical Research

Novartis Captures the Latest Biological Knowledge for Drug Discovery

Bioinformatics

Fortune 200 IT Services Company

Transforms & Accelerates Customer Engagement with Real-Time Matching of Capabilities to Client Needs

Digital Transformation (DX)

Quander Brings Consumer Data to Life for Big-Brand Clients Experimenting with New Immersive Digital Experiences

Data Lineage Tool Improves Risk Management, Drives Compliance

Business Intelligence

NBC News Analyzes Hundreds of Thousands of Russian Troll Tweets Using Neo4j

CAST Software

Graph Technology Fuels Rapid Development of IT Architecture Visibility Solution

Monoliths to Microservices: Improving Code Quality with Graph Technology

Graph Technology Enhances Gamer Engagement on Faceit

Graph Technology Helps Xfinity Create Personalized, Smart Homes

Caterpillar

Neo4j Provides Natural Language Processing at Scale, Making Equipment Repair More Efficient

Ad Tech Agency

Identity Graph Analysis at Scale Provides Ad Tech Agency Customers with Greater ROI

Global 50 Bank

How Graph Technology & AI Helped a Global 50 Bank Lend in Latin America

Perform Media

A Graph-Powered Single Customer View Improves Data Monetization

Money Laundering Prevention with Neo4j

Digitate, a TCS Venture, Selects Neo4j to Power Its Flagship AI Product

Real-Time Graph Analysis of Documents Saves Company Over 4 Million Employee Hours

Lockheed Martin Space

From Scientists to Satellites: Lockheed Martin Tackles Disparate Life Cycle Data with a Product 360 System

Neo4j Powers Intelligent Commerce for eBay App on Google Assistant

German Centre for Diabetes Research (DZD)

Knowledge Graph-Powered Diabetes Research

Gousto Is Using Graph Technology to Personalise Its Ingredient Lists

Investor IQT Uses Neo4j to Help U.S. Intelligence Agencies Find the Best Cutting-Edge Technology

Neo4j Keeps the Army Running by Tracking Equipment Maintenance

Neo4j Helps Photo Organization Service Monetize Relationships in 1.2 Petabytes of Data

Product Catalog

Fast-Track Content Management Application Development with Neo4j

Master Data Management

Fortune 50 Retailer

Neo4j Transforms Performance of Global Retailer’s Website after Cyber Monday Failings

Fortune 200 Hospitality Company

Fortune 200 Hospitality Company Uses Neo4j to Fight Off Airbnb and Booking.com

Fortune 500 Financial Services Company

Real-Time Graph Analysis Creates Potential for Millions in Fraud Detection Savings

Neo4j Enables Hästens to Create 360-Degree View of Customers & Drive Ecommerce Worldwide

Candiolo Cancer Institute (IRCC)

Flexible Data Models Provide Life-Saving Insights into Complex Cancer Research Data

WineDataSystem

WDS Revamps Its Resource for Wine Professionals in Less Than Four Months

Neo4j Provides Musimap with a Real-Time Recommendation and Search Engine for the Music Industry

A Fluid Technical Transition to Digitalization in the Printing Industry with Neo4j

Network and IT Operations

Transparency-One

Transparency-One Offers Total Supply Chain Transparency to Large Retailers and Manufacturers with Neo4j

Neo4j Frees Travelers to Wanderu Across America

migRaven Makes Access Rights Migration Simple and Quick with Neo4j

Identity and Access Management

megree chooses Neo4j for its scalability, REST API and high availability

Social Network

Die Bayerische

A clear overview of all contract information thanks to Neo4j

Wazoku integrates Neo4j seamlessly in its polyglot solution

The ICIJ – Swiss Leaks Story

How the ICIJ Used Graph Database Technology to Uncover the Swiss Leaks Story

Companies and Their Economic Connections Are More Transparent Thanks to Big Data Intelligence

Telenor Resource Authorization Challenge Solved with the Neo4j Graph Database

Next-Gen Master Data Management Comes to Marketing at Precisely

Global 500 Logistics

Transforming Logistics: Real-time Routing and Tracking with Neo4j

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications You must be signed in to change notification settings

A comprehensive collection of SQL case studies, queries, and solutions for real-world scenarios. This repository provides a hands-on approach to mastering SQL skills through a series of case studies, including table structures, sample data, and SQL queries.

tituHere/SQL-Case-Study

Folders and files.

Library Management System (LMS) Database: Case Study Analysis

95 Pages Posted: 9 Oct 2022

GPDCM Jayasekara

University of Plymouth; NSBM Green University Town

Date Written: September 7, 2022

A library service wants to create a database to store details of its libraries, books, and borrowers. Details include the following: A book has a unique ISBN number, a title and one or more authors. The library service may own several copies of a given book, each of which is in one of the service’s libraries. A given library contains many books, and to distinguish different copies of the same book a library assigns a different copy-number to each of its copies of a given book; the price that was paid for each copy is also recorded. Every library has a unique name and is either a main library or a branch library. A main library may have zero or more branch libraries and every branch library is a branch of exactly one main library. A borrower has a name and a unique ID code. A borrower can have many books on loan, but each copy of a book can only be on loan to one borrower. A borrower could borrow the same book on several occasions, but it is assumed that each such loan will take place on a different date. The main operation and the details are included here & the developers can suggest some new options and services for the above system. To implement the new and advanced options you can assume any database related structures and constrains.

Keywords: Library, DB, SQL, ER, Database, System

Suggested Citation: Suggested Citation

Chamoth Madushan Jayasekara (Contact Author)

University of plymouth ( email ).

Plymouth United Kingdom 0701245270 (Phone)

NSBM Green University Town ( email )

Pitipana - Thalagala Rd Homagama Sri Lanka 0701245270 (Phone)

Do you have a job opening that you would like to promote on SSRN?

Paper statistics, related ejournals, data science, data analytics & informatics ejournal.

Subscribe to this fee journal for more curated articles on this topic

Information Curation, Management & Organization eJournal

Libraries & information technology ejournal.

Case studies on the implementation and use of database management systems

New citation alert added.

This alert has been successfully added and will be sent to:

You will be notified whenever a record that you have chosen has been cited.

To manage your alert preferences, click on the button below.

New Citation Alert!

Please log in to your account

Information & Contributors

Bibliometrics & citations, view options, index terms.

Information systems

Data management systems

Recommendations

Case studies on the implementation and use of database management systems (panel discussion): experience with resistance.

The most dramatic advance of the past decade in software technology has been the development of database management systems (DBMS). There is little question about the potential of these systems for enhancing system support to managers and users while ...

Case studies on the implementation and use of database management systems: Installing the first database application

The potential of database management systems for enhancing system support to managers and users while reducing design, structuring and maintenance problems is well known. Many database packages are available to assist those organizations pursuing this ...

Database Management Systems

Information, published in.

• ACM: Association for Computing Machinery

Association for Computing Machinery

New York, NY, United States

Publication History

Permissions, check for updates, contributors, other metrics, bibliometrics, article metrics.

• 0 Total Citations
• 405 Total Downloads
• Downloads (Last 12 months) 32
• Downloads (Last 6 weeks) 4

View options

View or Download as a PDF file.

View online with eReader .

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Share this publication link.

Copying failed.

Share on social media

Affiliations, export citations.

• Please download or close your previous search result export first before starting a new bulk export. Preview is not available. By clicking download, a status dialog will open to start the export process. The process may take a few minutes but once it finishes a file will be downloadable from your browser. You may continue to browse the DL while the export process is in progress. Download
• Download citation
• Copy citation

We are preparing your search results for download ...

We will inform you here when the file is ready.

Your file of search results citations is now ready.

Your search export query has expired. Please try again.

Case Studies: Databases

• Getting Started
• Harvard (HBR) Case Studies
• Free Case Studies

Library Databases

Find case studies using the library databases   on many topics, such as business, psychology, public administration, etc., it's easy when you use journal finder..

Option 1: Search by a journal title for case studies.

Start at the Business Library homepage . Look for the SEARCH E-JOURNALS search box.

Type in the SEARCH E-JOURNALS search box and enter the title of the journal. Select the database from the dropdown. Click Search within this publication .

Consider these journals:

• Journal of Information Technology Teaching Cases
• International Journal of Management Cases : IJMC
• Journal of the International Academy for Case Studies
• Business Case Journal
• Journal of Critical Incidents

Option 2: Find journal titles and then search for case studies.

In the SEARCH E-JOURNALS search box type case studies or case research . Browse the journal title list and select a title - click the database (under the Journal's name). Click Search within this publication.

Click Search within this publication . The database opens.

Now, click search and browse the full list of available case studies. Filter by publication year.

Add a simple keyword to focus your search on your area of interest. Keep the concept broad: management, strategic, discrimination, information management.

Search tips for the library catalog & databases:

• Keyword search: Add quotation marks to group significant words together. For example: "case studies" "supply chain".
• Filter your results: If the database has the menu option, select case studies. For example, Business Source Complete. Advanced Search screen - Publication Type - Case Studies.
• The term "case study" often appears in the document title- try adding "case study" to a title search
• Try searching with various terms, case study or case studies ; or use punctuation to find all forms - type this: case stud*

Business Library Databases with case studies:

• Academic Search Complete (via Ebsco) This link opens in a new window Multidisciplinary and peer-reviewed journals, periodicals, reports, and eBooks with comprehensive coverage in key areas of academic study. Help Guide
• Business Source Complete (via Ebsco) This link opens in a new window All disciplines of business are included--marketing, management, MIS, POM, accounting, finance and economics. Additional full text, non-journal content includes financial data, eBooks, monographs, major reference works, book digests, conference proceedings, case studies, investment research reports, industry reports, market research reports, country reports, Company profiles, SWOT analyses and more. . Help Guide
• CaseBase (via Gale eBooks) Covers business case studies focused on issues in emerging markets and emerging industries across the globe. (2012)
• Encyclopedia of Global Brands (via Gale eBooks) Contains 270 entries, written in case-study style, that highlight interesting details including how a product originated and was first marketed, how it developed commercially and how it fares today compared with its competitors and its own past history. Included are anecdotes pertaining to the famous, or infamous, marketing strategies and advertising campaigns that managed to capture the sometimes jaded viewers' attention.
• Encyclopedia of Major Marketing Strategies (via Gale eBooks) Over 100 essays covering some of the top global and emerging brands that appeared from 2014 to 2018. Essays are aligned to the strategic marketing framework, ensuring that the marketing strategies covered can easily be utilized in an academic environment as case studies, or illustrative examples often described as “war stories” by professors.
• O'Reilly eBooks and Video This link opens in a new window More than 40,000 books, videos, case studies, and interactive tutorials. Especially strong for IT and business-related resources.
• ProQuest (Multi-Database Search) This link opens in a new window Access to multiple ProQuest databases in one click. Provides full text journal, magazine, and newspaper articles. Scholarly and general interest literature in business, social sciences, science and technology, and humanities. Help Guide
• SAGE Journals This link opens in a new window Peer-reviewed articles covering a wide range of subject areas including business, humanities, social sciences, and science, technology, and medicine. Access all journal volumes/issues from January 1, 1999 to the present. Help Guide
• Science Direct Search for peer-reviewed journals, articles, and open access content. The library has access to the Social and Behavioral Sciences subject collection of journals.
• Social Science Research Network (SSRN) eLibrary This link opens in a new window Provides over 900,000 research papers in the social sciences (including business) from over 470,000 researchers in more than 50 disciplines. FAQs
• << Previous: Ebooks
• Next: Harvard (HBR) Case Studies >>
• Last Updated: Jun 7, 2024 1:08 PM
• URL: https://ggu.libguides.com/casestudies

Academia.edu no longer supports Internet Explorer.

To browse Academia.edu and the wider internet faster and more securely, please take a few seconds to  upgrade your browser .

Enter the email address you signed up with and we'll email you a reset link.

• We're Hiring!
• Help Center

HOSPITAL PATIENT DATABASE MANAGEMENT SYSTEM A Case Study of General Hospital NORTH-BANK Makurdi-Nigeria

Related Papers

Mahfooz Ahmed

This study was carried out to design and introduce the use of an automated clinic record management system and has chosen Ahmadu Bello University Sick-bay as the case study for the first implementation with the aim of improving their services especially in this digital era. A qualitative research was adopted and the instrument used for the study are interview, observation and questionnaire where some questions were raised by the researcher such as, what are the challenges associated with the use of the current manual record management system in the Ahmadu Bello University Sick-bay? How to improve on the current manual record managements system to minimize human error in the process of the records? How to improve on the current manual time management among the staff of the clinic? And how to provide more privacy to patients’ records and information in the clinic? Fifteen (15) respondents were randomly chosen from both the clients and staff of the clinic. And at the end of the research, the findings were analyzed which led to the designing of the aforementioned system. And in order to design the programme, the researcher uses some web development tools such as; Adobe Dreamweaver and Notepad Plus Plus for the required coding; hypertext preprocessor (PHP) and Java scripts (JS) to connect the interfaces to the database; and My-SQL was used to design the databases that store the overall system data. Finally; summary, conclusion and suggestion were given on the problems associated with the manual method of record keeping such as difficulties in sorting, retrieving and updating records, lack of security of records, loss of relevant information and so on, it was also suggested that the implementation of this programme will help in improving the effectiveness and efficiency in our clinics.

Desmond Okocha , Nasiru Sani

The need for effective health care in Nigeria as in many other countries is face with growing demand for effective health care services due to growing population and higher standard for the quality of life, the study was conducted through cross-sectional design. It aim at assessing the best practices in patient data management for effective health care service delivery.Data was collected from Doctors, Nurses, medical laboratory staff, medical record staff and patients. Patients were interviewed in the selected tertiary hospitals of Jigawa state. A total of five hundred (500) medical personnel and patients were involved in the selected tertiary hospitals in Jigawa state of Nigeria. Data were analyzed using descriptive statistics. The Findings revealed manual method is the method used at the selected tertiary hospitals in capturing patient information. This finding is in agreement with study from Nigeria that showed that there was no awareness of the use of computers for record management in hospitals and this affected EMR technology adoption. It was concluded that the use of electronic health record will increase the efficiency of health if implemented according to the best practices.

Gregory ONWODI

There is a need for the development of an efficient information system in our hospitals. Inefficient medical information systems, over time, have often resulted in manual operations, which in turn require more employees, and reduce the profitability of medical practices. Clinical Database Information System is not a new technology in the medical industry. In recent years, Clinical Database Information System has been implemented all around the world Nigeria inclusive. Gbagada general hospital is a foremost hospital in Lagos. Some of processes in the hospital have been automated, but sophisticated features of the Clinical Database Information System need be included. In this paper, we have identified the need to develop Clinical Database Information System for Gbagada General Hospital. Some of the problems identified during our analysis were the issue of consultation report. This is a very vital feature that a system should provide. This makes it easier for another medical practition...

Kolawole Ayanlowo

Abstract-We live in an era when manual systems are becoming obsolete and being replaced by e-platforms for enhanced efficiency and better productivity. In this paper, an attempt was made to develop an automated record management system for a typical health institution. The record systems of five hospitals in south-west Nigeria were used as case studies for evolving a robust and comprehensive design for the electronic database. Java programming language (NetBeans IDE 6.7.1) was used to develop the application while MySQL was used as the query language. The application offers numerous advantages over the traditional manual record-keeping system among which are data consistency, data integrity, ease of data retrieval, record integration and data mining.

nageema shaik

Database Management System (DBMS) Project

Surajo Tafida Kazaure

Since most of our hospitals are operating manual health records, there is the need to Design a good and comprehensive database management system will boast and improve good health records system in hospital setting.

Sulaiman Badamasi

The need for centralized patients records support critical decisions making in hospitals and other health institution cannot be disputed; however, development of such systems requires an understanding of the actual information needs of public health professionals. This paper reports the results of a literature review on essence of centralization of patient health records, effect of decentralization of patient case folders, major indices on patient information, the need for centralized records or E-health records as whole for it importance and relevance to our modern society and lastly, bed stay which consists of number of case note received and number of discharges from January to December, 2016 at the national orthopedic hospital Dala, kano state of Nigeria. The review was undertaken in order to develop system requirements to inform the design and development of centralized patient&#39;s record for knowledge information management system. Moreover, the goal of the system is to supp...

Patient record management systems in hospital today necessitate a competent administration when handling patients, generating reports from cashier, patient details which serves as a key factor for the flow of business transactions in Kinoni Health center. Unfortunately, the current Record management system leads to misplacement of drug details, payment details, and late release of reports and insecurity to records. This research project is aimed at computerizing all the records about patients, staff and drug suppliers. In order to achieve this goal, a thorough System Study and investigation was carried out and data was collected and analyzed about the current system using document and data flow diagrams. The concept of report production has been computerized hence, no more delay in report generation to the hospital manager. Errors made on hand held calculators are dealt out completely.

Cornerstone Medical Information System

Mutungi Alian

This study is established on developing a Medical Information system that will be in position to succumb the problems that are currently being faced by paper based information system. This is system is created to be web based and is to run on the server by using server side scripting such as PHP with Apache web server. In case the organization has no internet it can use a standalone desktop application that runs on windows system.

International Journal of Computer Theory and Engineering

Ezenwa Nwawudu

Loading Preview

Sorry, preview is currently unavailable. You can download the paper by clicking the button above.

RELATED PAPERS

Rajesh Mane

UNIZIK JOURNAL OF BUSINESS

Gloria Emokhare

Nur Syatirah

Advances in Electronic Government, Digital Divide, and Regional Development

Vusi Tsabedze

Rwanda Journal of Medicine and Health Sciences

Nasiru Sani

Ijaems Journal

IJRCAR JOURNAL

International Journal for Research in Applied Science & Engineering Technology (IJRASET)

IJRASET Publication

Medical record and health care information journal

Rafsan Jani

Stephen Ajayi

International Journal of Advanced Trends in Computer Science and Engineering

WARSE The World Academy of Research in Science and Engineering

International Journal of Health and Pharmaceutical (IJHP)

Muhammad Hasan Nasution

ABUBAKAR MUHAMMED BASHIR

ABUBAKAR M U H A M M E D Bashir

Deepak Tripathee

IAEME Publication

Lanisa Nauli Sitorus

Human Resource and Leadership Journal

International Journal of Research in Library Science

Amina Makintami

KESANS : International Journal of Health and Science

Ilham Muharam

JISTEM Journal of Information Systems and Technology Management

Pedro Luiz Cortês

OCHAN K A L U N G I JIMMY

RELATED TOPICS

•   We're Hiring!
•   Help Center
• Find new research papers in:
• Health Sciences
• Earth Sciences
• Cognitive Science
• Mathematics
• Computer Science
• Academia ©2024

• Engineering Mathematics
• Discrete Mathematics
• Operating System
• Computer Networks
• Digital Logic and Design
• C Programming
• Data Structures
• Theory of Computation
• Compiler Design
• Computer Org and Architecture

DBMS Tutorial – Learn Database Management System

Database Management System is a software or technology used to manage data from a database. Some popular databases are MySQL, Oracle, MongoDB, etc. DBMS provides many operations e.g. creating a database, Storing in the database, updating an existing database, delete from the database. DBMS is a system that enables you to store, modify and retrieve data in an organized way. It also provides security to the database.

In this Database Management System tutorial you’ll learn basic to advanced topics like ER model, Relational Model, Relation Algebra, Normalization, File Organization, etc.

Table of Content

Introduction :

Entity relationship model :, relational model :, relational algebra :, functional dependencies :, normalisation :, transactions and concurrency control :, indexing, b and b+ trees :, file organization:, advanced topics :, sql tutorial, advantages of dbms, disadvantages of dbms, quick links :.

• DBMS Introduction | Set 1
• DBMS Introduction | Set 2 (3-Tier Architecture)
• DBMS Architecture 2-level 3-level
• Need For DBMS
• Data Abstraction and Data Independence
• Database Objects
• Multimedia Database
• Categories of End Users
• Use of DBMS in System Software
• Choice of DBMS | Economic factors
• Enhanced ER Model
• Minimization of ER Diagram
• ER Model: Generalization, Specialization and Aggregation
• Recursive Relationships
• Impedance Mismatch
• Relational Model and CODD Rules
• Relational Model
• Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
• Number of possible Superkeys
• Anomalies in Relational Model
• Mapping from ER Model to Relational Model
• Strategies for Schema design
• Schema Integration
• Star Schema in Data Warehouse modeling
• Data Warehouse Modeling | Snowflake Schema
• Dimensional Data Modeling

>> Quiz on ER and Relational Model

• Introduction
• Basic Operators
• Extended Operators
• Inner Join vs Outer Join
• Join operation Vs nested query
• DBMS | Tupple Relational Calculus
• Row oriented vs. column oriented data stores
• How to solve Relational Algebra Problems for GATE
• How to Solve Relational Algebra Problems for GATE
• Functional Dependency and Attribute Closure
• Finding Attribute Closure and Candidate Keys using Functional Dependencies
• Armstrong’s Axioms in Functional Dependency
• Equivalence of Functional Dependencies
• Canonical Cover
• Normal Forms
• Minimum relations satisfying 1NF
• The Problem of redundancy in Database
• Dependency Preserving Decomposition
• Lossless Join Decomposition
• LossLess Join and Dependency Preserving Decomposition
• How to find the Highest Normal Form of a Relation
• Domain Key normal form
• Introduction of 4th and 5th Normal form
• Denormalization in Databases
• DBMS | Data Replication

>> Quiz on Normal Forms

• ACID Properties
• Concurrency Control -Introduction
• Implementation of Locking in DBMS
• Concurrency Control Protocols – Lock Based Protocol
• Concurrency Control Protocol | Graph Based Protocol
• Concurrency Control Protocol | Two Phase Locking (2-PL)-I
• Concurrency Control Protocol | Two Phase Locking (2-PL)-II
• Concurrency Control Protocol | Two Phase Locking (2-PL)-III
• Concurrency Control Protocol | Multiple Granularity Locking
• Concurrency Control Protocol | Thomas Write Rule
• Concurrency Control | Polygraph to check View Serializabilty
• DBMS | Log based recovery
• Timestamp Ordering Protocols
• Introduction to TimeStamp and Deadlock Prevention Schemes
• Dirty read in SQL
• Types of Schedules
• Conflict Serializability
• View Serializability
• How to test if two schedules are View Equal or not ?
• Recoverability of Schedules
• Precedence Graph for testing Conflict Serializabilty
• Transaction Isolation Levels in DBMS
• Database Recovery Techniques
• Starvation in DBMS
• Deadlock in DBMS
• DBMS | OLAP vs OLTP
• Types of OLAP Systems
• DBMS | Types of Recoverability of Schedules and easiest way to test schedule | Set 2
• Web Information Retrieval | Vector Space Model
• Why recovery is needed?

>> Quiz on Transactions and concurrency control

• Indexing and its Types
• B-Tree | Set 1 (Introduction)
• B-Tree | Set 2 (Insert)
• B-Tree | Set 3 (Delete)
• B+ Tree (Introduction)
• Bitmap Indexing
• Inverted Index
• Difference between Inverted Index and Forward Index
• SQL queries on clustered and non-clustered Indexes

>> Practice questions on B and B+ Trees >> Quizzes on Indexing, B and B+ Trees

• File Organization – Set 1
• File Organization – Set 2 (Hashing in DBMS)
• File Organization – Set 3
• File Organization – Set 4

>> Quiz on File structures

• Query Optimization
• How to store a password in database?
• Storage Area Networks
• Network attached storage
• Data Warehousing
• Data Warehouse Architecture
• Characteristics and Functions of Data warehouse
• Difficulties of Implementing Data Warehouses
• Data Mining
• Data Mining | KDD process
• Data Mining | Sources of Data that can be mined
• ODBMS – Definition and overview
• Architecture of HBase
• Apache HBase
• Architecture and Working of Hive
• Apache Hive
• Difference between Hive and HBase
• Difference between RDBMS and HBase
• Challenges of database security
• Federated database management system issues
• Distributed Database System
• Functions of Distributed Database System
• Semantic Heterogeneity
• Advantages of Distributed database
• Comparison – Centralized, Decentralized and Distributed Systems
• Characteristics of Biological Data (Genome Data Management)
• Data Management issues in Mobile database
• Future Works in Geographic Information System
• Difference between Structured, Semi-structured and Unstructured data
• SQL | Tutorials
• Quiz on SQL

DBMS practices questions :

• Database Management Systems | Set 1
• Database Management Systems | Set 2
• Database Management Systems | Set 3
• Database Management Systems | Set 4
• Database Management Systems | Set 5
• Database Management Systems | Set 6
• Database Management Systems | Set 7
• Database Management Systems | Set 8
• Database Management Systems | Set 9
• Database Management Systems | Set 10
• Database Management Systems | Set 11

There are some following reasons to learn DBMS:

• Organizing and management of data: DBMS helps in managing large amounts of data in an organized manner. It provides features like create, edit, delete, and read.
• Data Security: DBMS provides Security to the data from the unauthorized person.
• Improved decision-making: From stored data in the database we can generate graphs, reports, and many visualizations which helps in decision-making.
• Consistency: In a traditional database model all things are manual or inconsistent, but DBMS enables to automation of the operations by queries.
• Complexity: DBMS can be hard to design, implement, and manage, needing specialized knowledge.
• Cost: High setup costs, including hardware, software, and skilled personnel, can be expensive. Ongoing maintenance adds to the cost.
• Performance Overhead: DBMS might slow down simple tasks due to their extra features and general-purpose nature.
• Security Risks: Centralizing data can create security risks. If the system is hacked, all data could be compromised.
• Resource Intensive: DBMS need a lot of memory, storage, and processing power, which can be costly.
• Data Integrity Issues: Complex systems can lead to data integrity problems if not managed well.

Understanding Database Management Systems (DBMS) is essential for managing and organizing data effectively. This DBMS tutorial has introduced you to key concepts like database models, SQL queries, normalization, and data security. With this knowledge, you can design efficient databases, maintain data integrity, and improve performance.

Database Management System(DBMS) – FAQs

Q.1 what is database.

A database is a collection of organized data which can easily be created, updated, accessed, and managed. Records are kept maintained in tables or objects. A tuple (row) represents a single entry in a table. DBMS manipulates data from the database in the form of queries given by the user.

Q.2 What are different languages present in DBMS?

DDL (Data Definition Language) : These are the collection of commands which are required to define the database. E.g., CREATE, ALTER, RENAME, TRUNCATE, DROP, etc. DML (Data Manipulation Language) : These are the collection of commands which are required to manipulate the data stored in a database. E.g., SELECT, UPDATE, INSERT, DELETE, etc. DCL (Data Control Language) : These are the collection of commands which are dealt with the user permissions and controls of the database system. E.g, GRANT, and REVOKE. TCL (Transaction Control Language) : These are the collection of commands which are required to deal with the transaction of the database. E.g., COMMIT, ROLLBACK, and SAVEPOINT.

Q.3 What are the ACID properties in DBMS?

The full form of ACID is Atomicity, Consistency, Isolation, and Durability these are the properties of DBMS that ensure a safe and secure way of sharing data among multiple users. A  – Atomic: All changes to the data must be performed successfully or not at all. C  – Consistent: Data must be in a consistent state before and after the transaction. I  – Isolated: No other process can change the data while the transaction is going on. D  – Durable: The changes made by a transaction must persist.

Q.4 What are the Advantages of DBMS?

The followings are the few advantages of DBMS : Data Sharing:  Data from the same database can be shared by multiple users at the same time. Integrity:  It allows the data stored in an organized and refined manner. Data Independence:  It allows changing the data structure without changing the composition of executing programs. Data Security:  DBMS comes with the tools to make the storage and transfer of databases secure and reliable. Authentication and encryption are the tools used in DBMS for data security.

• Last Minutes Notes(LMNs) on DBMS
• Quizzes on DBMS
• DBMS interview questions | Set 1
• DBMS interview questions | Set 2

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

Please Login to comment...

Similar reads, improve your coding skills with practice.

What kind of Experience do you want to share?