Tags » Database Management System

Role of Database Management System in an Organization

Business organizations depend heavily on accurate data and information for proper functioning, updating and tracking. Within the organizations, employees use various data to complete their accounting works, calculate sales and create invoices for their customers. 524 more words

Database Management System

SQL Practice | Day 4

SCHEMA:

REGIONS(REGION_ID, REGION_NAME)
COUNTRIES(COUNTRY_ID, COUNTRY_NAME, REGION_ID)
LOCATIONS(LOCATION_ID, STREET_ADDRESS, POSTAL_CODE, CITY,STATE_PROVINCE, COUNTRY_ID)
DEPARTMENTS(DEPARTMENT_ID, DEPARTMENT_NAME, MANAGER_ID,LOCATION_ID)
EMPLOYEES(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
JOB_HISTORY(EMPLOYEE_ID, START_DATE, END_DATE, JOB_ID, DEPARTMENT_ID)
JOBS(JOB_ID, JOB_TITLE, MIN_SALARY, MAX_SALARY)
… 332 more words
MYSQL

SQL Practice | Day 3

Member(mid, mname, email, address)
Books(bid, bname, yearOfPublication, publisher)
Borrows(mid, bid, date)
Author(aid, aname)
Writes(bid, aid)

Question1: Find the name of the books either published before 1980 or are “Computer” related. 158 more words

MYSQL

Application of Data Mining in Customer Relationships Management (CRM)

Application of Data Mining in Customer Relationships Management (CRM)

Puneet Shukla

 

Data mining memungkinkan perusahaan untuk menentukan hubungan antara faktor “internal” seperti harga, penentuan posisi produk, atau keterampilan staf, dan faktor “eksternal” seperti indikator ekonomi, persaingan, dan demografi pelanggan untuk menentukan dampaknya terhadap penjualan, kepuasan pelanggan, dan keuntungan perusahaan. 110 more words

SQL Query | Day 2

A. Find the last names of all employess that work in SALES department.

SELECT substring(FullName,charindex(' ',FullName)+1,len(FullName)) as LastName 
		FROM Employees
		WHERE dept_id =  (SELECT dept_id
				  FROM Department
				  WHERE name = "SALES" ) ); 193 more words
MYSQL

SQL Query Practice | Day 1

SCHEMA=
student(sid, name)
Courses(cid, cname, fid)
Takes(sid, cid, year, CGPA)
Faculty(fid, fname)

**Find the no. of courses taken per year by each student.

SELECT sid, COUNT(cid), year
FROM Takes
GROUP BY sid, year; 123 more words
MYSQL

Database Management System (DBMS) Market 2018 Global Industry Trends and Forecast Analysis to 2025

WiseGuyReports.Com  adds  “Database Management System (DBMS) Market 2018 Global Industry Trends and Forecast Analysis to 2025” Research to its Database.

Description:                                                                                                 

This report studies the global… 567 more words

Bussiness