Preview

Marketing

Good Essays
Open Document
Open Document
856 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Marketing
Tugas mandiri
Andre nanda pratama jaelani, 112400161, MBTIe

CREATE TABLE DEPARTMENT
(dept_id VARCHAR (5) NOT NULL,
Nama_Dept VARCHAR (20) NOT NULL,
PRIMARY KEY (DEPT_id));

CREATE TABLE PEGAWAI
(ID_peg INT (5) NOT NULL,
Nama_peg VARCHAR (20) NOT NULL,
Alamat VARCHAR (20) NOT NULL,
ID_Dept VARCHAR (5) NOT NULL,
PRIMARY KEY (ID_peg),
FOREIGN KEY (ID_Dept) references pegawai (ID_peg));

INSERT INTO Department VALUES
('B001','HRC'),
('B002','IT'),
('B003','FINANCE'),
('B004','LOGISTIC');

INSERT INTO Pegawai VALUES
(100,'abas','madura','B001'),
(101,'bejo','magelang','B002'),
(102,'cecev','cicaheum','B001'),
(103,'ratu','ciawi_tali','B003'),
(104,'monalisa','cigiringsing','B002'),
(105,'sari','antapani','B004'),
(106,'rian','cicaheum','B003'),
(107,'bruno','magelang','B001'),
(108,'asep','cibiru','B002'),
(109,'dadang','cicaheum','B004'),
(110,'iis','magelang','B003');

select ID_peg,nama_peg,alamat,ID_dept from pegawai where (alamat='cicaheum');

select Nama_peg,nama_Dept from pegawai,Department where (alamat='magelang') and (ID_dept=dept_id);

Select ID_peg, Nama_Peg from Pegawai, department where (id_dept=dept_id) and (dept_id='B001');

Tugas individu.

CREATE TABLE EMPLOYEE (Fname VARCHAR(15) NOT NULL, Minit CHAR, Lname VARCHAR(15) NOT NULL, Ssn CHAR(9) NOT NULL, Bdate DATE, Address VARCHAR(30), Sex CHAR, Salary DECIMAL(10,2), Super_ssn CHAR(9), Dno INT NOT NULL,
PRIMARY KEY(Ssn),
FOREIGN KEY(Super_ssn) REFERENCES EMPLOYEE(Ssn));

CREATE TABLE DEPARTEMENT (Dname VARCHAR(15) NOT NULL, Dnumber INT NOT NULL, Mgr_ssn CHAR(9) NOT NULL, Mgr_start_date DATE,
PRIMARY KEY(Dnumber),
FOREIGN KEY(Mgr_ssn) REFERENCES EMPLOYEE(Ssn));

CREATE TABLE DEPT_LOCATIONS
(Dnumber INT NOT NULL,
Dlocation VARCHAR(15) NOT NULL,
PRIMARY KEY(Dnumber, Dlocation),
FOREIGN KEY(Dnumber) REFERENCES DEPARTMENT(Dnumber));

CREATE TABLE PROJECT (Pname VARCHAR(15) NOT NULL, Pnumber INT NOT NULL, Plocation VARCHAR(15), Dnum INT NOT NULL,
PRIMARY KEY(Pnumber),
FOREIGN

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Hiredate DATE No No Job VARCHAR2(15) No No Mgrno number(4) no no yes ( to emp.empno) Salary number(8,2) no no Comm number(8,2) no no Deptno number(2) no no yes ( to…

    • 1169 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    Assignment 1

    • 1280 Words
    • 13 Pages

    Write triggers, according to Oracle style, to enforce the constraint that no employee is allowed to…

    • 1280 Words
    • 13 Pages
    Good Essays
  • Good Essays

    Sql basics

    • 584 Words
    • 3 Pages

    The SQL CROSS JOIN produces a result set which is the number of rows in the…

    • 584 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Marketing

    • 3920 Words
    • 16 Pages

    The following marketing plan for Karicare has been created by its three international marketing consultants to secure additional funding for growth and to inform employees of company s current status and direction. Since 1896, Karicare was found by Dr Truby King, the firm has experienced greater demand for its products, and research show that racial similarity, role congruence, labeling intensity of ethnic identification, shared knowledge and ethnic salience all promote positive effects on the target market. Meanwhile, Karicare plans to explore opportunities for online sales. The marketing environment has been very receptive to the firm’s good quality of milk products. Over the following years, Karicare can increase…

    • 3920 Words
    • 16 Pages
    Powerful Essays
  • Satisfactory Essays

    The main Use-case diagram for “VowCabs Passenger app” shows how the user can access different modules of the application. The user has to first login. Later user can use the different operation of the application.…

    • 1585 Words
    • 7 Pages
    Satisfactory Essays
  • Good Essays

    marketing

    • 1575 Words
    • 10 Pages

    Before undertaking any research you need to be clear about what you want to find out. Here are some…

    • 1575 Words
    • 10 Pages
    Good Essays
  • Good Essays

    Marketing

    • 491 Words
    • 2 Pages

    In the article Marketing Strategies of Global Brand in Indian Markets by Journal of Arts, Science & Commerce talks about how India is among the largest markets in the world in terms of sheer size along with China which together account for 37 percent of the overall world population. Some of the global brands in Indian are Kellogg’s, Initial Blunders, McDonalds, and many more. Kellogg’s is one of the most successful global brands in the U.S which was worlds leading producer of cereal and convenience foods. It is hugely popular breakfast cereal brand that is being sold in 160 countries with sales turnover of $9 billion. They say when Kellogg’s first entered Indian in 1994, it heavily bet on transforming the Indian breakfast cereal market through switching breakfast habits of Indian consumers who were used to hot breakfast foods. Presently, Kellogg’s is estimated to hold about 60-65 percent of Indian’s Rs. 400 core worth of breakfast cereal markets. Another brand that made an in pack was McDonalds. McDonald’s made an entry into the Indian market at a very appropriate time as soon as the Indian government opened up its market to the Global brands. When they made entry into the Indian market they faced several challenges which it needed to manage so that it could be successful in such diverse market. After discussing cases of some specific brands, we can argue that the global brands failed mainly because they failed to understand the dynamics of the Indian consumers as well as the markets they were going to sere. So therefore they had to reframe their strategies and then enter the market with a completely changed mindset as per the market dynamics. In the article they state the global firms operating in Indian must try to be local as they can, by converting themselves into global brands i.e. being global at heart.…

    • 491 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Term Paper

    • 3098 Words
    • 13 Pages

    Here is the term paper on “Entrepreneur”. Preparing of this term paper helped us to earn experience and knowledge that would be needed in the field of job.…

    • 3098 Words
    • 13 Pages
    Powerful Essays
  • Powerful Essays

    Marketing

    • 1467 Words
    • 6 Pages

    Assignment Assessment Report |Campus: |Pune |Year/semester |1 | |Level: |ACL1 |Assignment Type |monthly | |Module Name: |Marketing fundamental |Assessor’s Name | | |Student’s Name: |Pradip Waghmare |Read Submission Date | 24/01/2012 | |e-mail id & Mob No |Pradip1waghmare@gmail.com, 9404006921 |Actual Submission Date |24/01/2012 | |Stream |Marketing |Submitted to : |Aarti Hinduja | Certificate by the Student: Plagiarism is a serious College offence. I certify that this is my own work. I have referenced all relevant materials.…

    • 1467 Words
    • 6 Pages
    Powerful Essays
  • Better Essays

    Marketing

    • 1946 Words
    • 7 Pages

    In this paper, a detailed analysis of the relevance of marketing concept in today’s world has been presented. Moreover, a managerial report is given on the implementation of marketing concept in McDonald’s Plc. The analysis on the influence of company’s chosen philosophy at its strategies and external environment is also given in the write-up. In the end recommendation have been made on how to implement successfully marketing concept as a management philosophy…

    • 1946 Words
    • 7 Pages
    Better Essays
  • Good Essays

    marketing

    • 1140 Words
    • 5 Pages

    The management process through which goods and services move from concept to the customer. It includes the coordination of four elements called the 4 P's of marketing:…

    • 1140 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Sudhakar

    • 1718 Words
    • 7 Pages

    1. Consider the following table named "GYM" with details about Fitness products being sold in the store.…

    • 1718 Words
    • 7 Pages
    Satisfactory Essays
  • Powerful Essays

    Marketing

    • 1554 Words
    • 7 Pages

    Marketing is selling of products or services, the business activity of presenting products or services in such a way as to make them desirable.…

    • 1554 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    Marketing

    • 448 Words
    • 2 Pages

    First, let’s define: what is marketing? It is the action or business of promoting and selling products or services. Marketing is much more than just selling and advertising. It plays an essential role in providing consumers with need-satisfying goods and services. Marketing is a subject that touches everyone’s life. It is the means by which a standard of living is developed and delivered to people. Well, marketing plays an important role in society and affects my everyday life. It offers outstanding career opportunities in such areas as professional selling, marketing research, advertising, retail buying, distribution management, product management and development and wholesaling or logistics. In a variety of non-business organizations including hospitals, museums, universities, government and social service agencies, marketing career opportunity also exist.…

    • 448 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Corruption

    • 38522 Words
    • 155 Pages

    To insert a new record again you have to type entire insert command, if there are lot of…

    • 38522 Words
    • 155 Pages
    Powerful Essays