I want a mini project in Database about (Library Management System Databaset should have this 4 phases , then the Query
Posted: Sun May 15, 2022 1:39 pm
I want a mini project in Database about (Library
Management System Databaset should have this 4 phases
, then the Query of the database :
Phase I: Requirements collection and Analysis
Phase II: Conceptual design: E-R Diagram
Phase III: Logical schema design mapping
Phase IV: Physical schema design – Internal Schema
QUERY FOR CREATING Library Management System DATABSE
These pictures are an example of what I want , but with
a different topic
PLEASE ANSWER ME QUICKLY
Mini Project Guideline_and_Sample Project 2022.pdf 9/13 | - 90% + TOUTES 7 COMPANY DATABSE (SAMPLE) In this section we describe a sample database application, called COMPANY, which serves to illustrate the basic ER model concepts and their use in schema design. We list the data requirements for the database here, and then create its conceptual schema step-by-step as we introduce the modeling concepts of the ER model. The COMPANY database keeps track of a company's employees, departments, and projects. Phase I: Requirements collection and Analysis (3 marks) Guidelines: After consultation, the following requirements for a company database have been determined 1. The company is organized into departments. Each department has a unique name, a unique number, and a particular employee who manages the department. Keep track of the start data when that employee began managing the department. A department may have several locations 2. A department controls a number of projects, each of which has a unique name, a unique number, and a single location 3. Store each employee's name, social security number, address, salary, sex, and birth date. An employee is assigned to one department, but may work on several projects, which are not necessarily controlled by the same department. Keep track of the number of hours per week that an employee works on each project. Also, keep track of the direct supervisor of each employee 4. Keep track of the dependents of each employee for insurance purposes. Keep each dependent's first name, sex, birth date, and relationship to the employee. SAMPLE MINI PROJECT 10 11 Page 7 of 10 12
Mini Project Guideline_and_Sample Project 2022.pdf 10/13 - 90% Phase II: Conceptual design: E-R Diagram (3 marks) SAMPLE MINI PROJECT Phase III: Logical schema design mapping marks) EMPLOYEE Frame Minit Lname SSN Bdate Address Sex Salary Dno 10 DEPARTMENT Dname number MGRSSN MarStartDate PROJECT Prame Pnumber Plocation Dnum 11 DEPENDENT ESSN Dependent Name Sex Bdate Relationship Page Bolo
Mini Project Guideline_and_Sample Project 2022.pdf 11/13 - 90% Phase IV: Physical schema design - Internal Schema (3 marks) SAMPLE MINI PROJECT QUERY FOR CREATING COMPANY DATABSE (10 MARKS FOR LAB) CREATE TABLE Department FEST Dname CHAR(20) Dnumber INTEGER NOT NULL MGRSSN INTEGER MGRSTARTDATE DATE Employee_SSN INTEGER NOT NULL, Project PNUMBER INTEGER NOT NULL ); ALTER TABLE Department ADD CONSTRAINT Department_PK PRIMARY KEY ( Dnumber) CREATE TABLE Dependent ESSN INTEGER NOT NULL, Papel 10
Mini Project Guideline_and_Sample Project 2022.pdf 12/13 - % + 909 Dependent Name CHARL70), NOT NULL, Sex CHAR(6). Bdate DATE Relationship CHAR(10), Employee SSN INTEGER NOT NULL ALTER TABLE Dependent ADD CONSTRAINT Dependent_PK PRIMARY KEY (ESSN, Dependent_Name, Employee 5SN): CREATE TABLE Employee Fname CHAR(10), Minit CHAR(10), Lname CHAR(10), SSN INTEGER NOT NULL, Bdate DATE Address CHAR(100), Sex CHAR(6), Salary INTEGER Project PNUMBER INTEGER ); ALTER TABLE Employee ADD CONSTRAINT Employee_PK PRIMARY KEY (SSN); SAMPLE MINI PROJECT CREATE TABLE Project 10 Pname CHAR(10), PNUMBER INTEGER NOT NULL Plocation CHAR(10), Dnumber INTEGER NOT NULL 11 ALTER TABLE Project ADD CONSTRAINT Project PK PRIMARY KEY (PNUMBER) ALTER TABLE Department ADD CONSTRAINT Department Employee FK FOREIGN KEY ( Employee_SSN) REFERENCES Employee (SSN): ALTER TABLE Department ADD CONSTRAINT Department_Project_FK FOREIGN KEY (Project_PNUMBER) REFERENCES Project (PNUMBER); ALTER TABLE Dependent ADD CONSTRAINT Dependent_Employee_FK FOREIGN KEY ( Fmployee SSN) REFERENCES Employee (SSN): ALTER TABLE Employee ADD CONSTRAINT Employee_Project_FK FOREIGN KEY( Project_PNUMBER ) REFERENCES Project (PNUMBER) Page 10 of 10
Management System Databaset should have this 4 phases
, then the Query of the database :
Phase I: Requirements collection and Analysis
Phase II: Conceptual design: E-R Diagram
Phase III: Logical schema design mapping
Phase IV: Physical schema design – Internal Schema
QUERY FOR CREATING Library Management System DATABSE
These pictures are an example of what I want , but with
a different topic
- I Want A Mini Project In Database About Library Management System Databaset Should Have This 4 Phases Then The Query 1 (131.62 KiB) Viewed 74 times
- I Want A Mini Project In Database About Library Management System Databaset Should Have This 4 Phases Then The Query 2 (81.13 KiB) Viewed 74 times
Mini Project Guideline_and_Sample Project 2022.pdf 9/13 | - 90% + TOUTES 7 COMPANY DATABSE (SAMPLE) In this section we describe a sample database application, called COMPANY, which serves to illustrate the basic ER model concepts and their use in schema design. We list the data requirements for the database here, and then create its conceptual schema step-by-step as we introduce the modeling concepts of the ER model. The COMPANY database keeps track of a company's employees, departments, and projects. Phase I: Requirements collection and Analysis (3 marks) Guidelines: After consultation, the following requirements for a company database have been determined 1. The company is organized into departments. Each department has a unique name, a unique number, and a particular employee who manages the department. Keep track of the start data when that employee began managing the department. A department may have several locations 2. A department controls a number of projects, each of which has a unique name, a unique number, and a single location 3. Store each employee's name, social security number, address, salary, sex, and birth date. An employee is assigned to one department, but may work on several projects, which are not necessarily controlled by the same department. Keep track of the number of hours per week that an employee works on each project. Also, keep track of the direct supervisor of each employee 4. Keep track of the dependents of each employee for insurance purposes. Keep each dependent's first name, sex, birth date, and relationship to the employee. SAMPLE MINI PROJECT 10 11 Page 7 of 10 12
Mini Project Guideline_and_Sample Project 2022.pdf 10/13 - 90% Phase II: Conceptual design: E-R Diagram (3 marks) SAMPLE MINI PROJECT Phase III: Logical schema design mapping marks) EMPLOYEE Frame Minit Lname SSN Bdate Address Sex Salary Dno 10 DEPARTMENT Dname number MGRSSN MarStartDate PROJECT Prame Pnumber Plocation Dnum 11 DEPENDENT ESSN Dependent Name Sex Bdate Relationship Page Bolo
Mini Project Guideline_and_Sample Project 2022.pdf 11/13 - 90% Phase IV: Physical schema design - Internal Schema (3 marks) SAMPLE MINI PROJECT QUERY FOR CREATING COMPANY DATABSE (10 MARKS FOR LAB) CREATE TABLE Department FEST Dname CHAR(20) Dnumber INTEGER NOT NULL MGRSSN INTEGER MGRSTARTDATE DATE Employee_SSN INTEGER NOT NULL, Project PNUMBER INTEGER NOT NULL ); ALTER TABLE Department ADD CONSTRAINT Department_PK PRIMARY KEY ( Dnumber) CREATE TABLE Dependent ESSN INTEGER NOT NULL, Papel 10
Mini Project Guideline_and_Sample Project 2022.pdf 12/13 - % + 909 Dependent Name CHARL70), NOT NULL, Sex CHAR(6). Bdate DATE Relationship CHAR(10), Employee SSN INTEGER NOT NULL ALTER TABLE Dependent ADD CONSTRAINT Dependent_PK PRIMARY KEY (ESSN, Dependent_Name, Employee 5SN): CREATE TABLE Employee Fname CHAR(10), Minit CHAR(10), Lname CHAR(10), SSN INTEGER NOT NULL, Bdate DATE Address CHAR(100), Sex CHAR(6), Salary INTEGER Project PNUMBER INTEGER ); ALTER TABLE Employee ADD CONSTRAINT Employee_PK PRIMARY KEY (SSN); SAMPLE MINI PROJECT CREATE TABLE Project 10 Pname CHAR(10), PNUMBER INTEGER NOT NULL Plocation CHAR(10), Dnumber INTEGER NOT NULL 11 ALTER TABLE Project ADD CONSTRAINT Project PK PRIMARY KEY (PNUMBER) ALTER TABLE Department ADD CONSTRAINT Department Employee FK FOREIGN KEY ( Employee_SSN) REFERENCES Employee (SSN): ALTER TABLE Department ADD CONSTRAINT Department_Project_FK FOREIGN KEY (Project_PNUMBER) REFERENCES Project (PNUMBER); ALTER TABLE Dependent ADD CONSTRAINT Dependent_Employee_FK FOREIGN KEY ( Fmployee SSN) REFERENCES Employee (SSN): ALTER TABLE Employee ADD CONSTRAINT Employee_Project_FK FOREIGN KEY( Project_PNUMBER ) REFERENCES Project (PNUMBER) Page 10 of 10