CI7300: Data Management and Governance Assignment Sample 2023
Introduction
The main aim of the delphi promotion company is to handle the all the adverdisment through electronic mode. When the client is approach to the company with product to manage the product along with the campaign range. The information maintanance is consider with the staff information, client, placement and the meeting details. The advertisememt options shows the information various mode of adverdisement aalong with the specialization of information.
The initial stage of the campaign is consider with the number meetinng conducted along with the client and staff for discussion aobut the product. All the campaign is consider with the advertisement and each advertisment is related to the advertisment code along with the types of advertisment that is newspaper, magazine, cinema, poster and web related proccess or any other format.
Delphi datatbase require to support their activities along with the staff details that is need to monitor the various activity and their involvement into their campaigns. Then consider with the client details including the differnet kind of contact along with the particular campaign.
The campaign details are mainntain with each product addvertisement process and then along with the meetinng details , advertise the product and placement details for the various process involvement.
Implementation
Staff information
CREATE TABLE STAFFDE (SID NUMBER PRIMARY KEY, SNAME VARCHAR2(20) NOT NULL, MOBILENO NUMBER NOT NULL, EMAILID VARCHAR2(20) NOT NULL, DESIGNATION VARCHAR2(20) NOT NULL);
Customer information
CREATE TABLE CUSTOMER (CUSID VARCHAR(20) PRIMARY KEY, CNAME VARCHAR2(20) NOT NULL, MOBILENO NUMBER NOT NULL, EMAIL VARCHAR2(20) NOT NULL);
Campaign Information
CREATE TABLE CAMPAIGN (CAMPAIGN1ID VARCHAR(20) PRIMARY KEY, PRODUCTINFORMATION VARCHAR2(20) NOT NULL, MANAGERNAME VARCHAR2(20) NOT NULL, SID NUMBER, CONSTRAINT FK_STAFFINF FOREIGN KEY (SID) REFERENCES STAFFDE(SID), CUSID VARCHAR(20), CONSTRAINT FK_CLIENT1 FOREIGN KEY (CUSID) REFERENCES CUSTOMER(CUSID));
Table for Meetingdetails
CREATE TABLE MEETINGDE (MEETINGDEID VARCHAR(20) PRIMARY KEY, STARTDATE DATE NOT NULL, PERIOD NUMBER, SID NUMBER, CONSTRAINT FK_STAFFME FOREIGN KEY (SID) REFERENCES STAFFDE(SID), CUSID VARCHAR(20), CONSTRAINT FK_CLIENTME FOREIGN KEY (CUSID) REFERENCES CUSTOMER(CUSID), CAMPAIGN1ID VARCHAR(20),
CONSTRAINT FK_CAMPAIGNME FOREIGN KEY (CAMPAIGN1ID) REFERENCES CAMPAIGN(CAMPAIGN1ID));
Componentdetails
CREATE TABLE COMPONENTDE (COMPONENTDEID VARCHAR(20) PRIMARY KEY, COMPNAMEVARCHAR2(20) NOT NULL);
Advertisementtable
CREATE TABLE ADVERTISEMENT (ADVID VARCHAR(20) PRIMARY KEY, CATEGORY VARCHAR(20) NOT NULL , EXPLANATION VARCHAR(20) NOT NULL, STARTDATE DATE NOT NULL, ENDDATE DATE NOT NULL, SIZEOFINTENT VARCHAR(20) NOT NULL , COMPONENTDEID VARCHAR(20), CONSTRAINT FK_COMPONENTDE FOREIGN KEY (COMPONENTDEID) REFERENCES COMPONENTDE(COMPONENTDEID) );
Placementdetails
CREATE TABLE PLACEMENTDE (PLACEMENTDEID VARCHAR(20) PRIMARY KEY, PLNAME VARCHAR(20) NOT NULL);
Distribution of Placement
CREATE TABLE PLACEMENTDIS (PDISID VARCHAR(20) PRIMARY KEY, ADVID VARCHAR(20), CONSTRAINT FK_ADIDP FOREIGN KEY (ADVID) REFERENCES ADVERTISEMENT(ADVID),CAMPAIGN1ID VARCHAR(20), CONSTRAINT FK_CAMPAIGNPL FOREIGN KEY (CAMPAIGN1ID) REFERENCES CAMPAIGN(CAMPAIGN1ID), PLACEMENTDEID VARCHAR(20), CONSTRAINT FK_PLACEMENTIDDIS FOREIGN KEY (PLACEMENTDEID) REFERENCES PLACEMENTDE (PLACEMENTDEID) );
Six Queries
- INSERT INTO STAFFDE VALUES (1001,’RAVI’,23468954,’[email protected]’,’DIRECTOR’);
select SID, SNAME, MOBILENO, EMAILID, DESIGNATION from STAFFDE
- INSERTINTOCUSTOMER VALUES(‘CUS1001′,’GOPI’,1234567,’[email protected]’);
select CUSID, CNAME, MOBILENO, EMAIL from CUSTOMER
- INSERT INTO CAMPAIGN VALUES (‘CAMP021′,’POSTER’,’KRISH’,1001,’CUS1001′);
select CAMPAIGN1ID, PRODUCTINFORMATION, MANAGERNAME, SID, CUSID from CAMPAIGN
- INSERT INTO MEETINGDE VALUES (‘MEC101′,’JUN-15-2019′,15,1001,’CUS1001′,’CAMP021’);
select MEETINGDEID, STARTDATE, PERIOD, SID, CUSID, CAMPAIGN1ID from MEETINGDE
[5]. INSERT INTO COMPONENTDE VALUES (‘COMP101′,’IMAGE’);
select COMPONENTDEID, COMPNAME from COMPONENTDE
[6] INSERT INTO ADVERTISEMENT VALUES(‘ADV101′,’MULTIMEDIA’,’IMAGE’,’MAR-02-2020′,’DEC-05-2020′,’A3′,’COMP101′);
SELECT *FROM ADVERTISEMENT
[7]. INSERT INTO PLACEMENTDEVALUES(‘PLA1′,’ADVERTISEMENT’);
SELECT *FROM PLACEMENTDE
[8]. INSERT INTO PLACMENTDIS VALUES(‘PDIS101′,’ADV101′,’CAMP021′,’PLA1’);
SELECT *FROM PLACEMENTDIS
Conclusion
The above information shows that the database is created using SQL statement. The database design and development is consider with class diagram generation along with the constraints and also it is directly involve with the various information of the process which is involve in the advertisement creation. All the campaign is consider with the advertisement and each advertisment is related to the advertisment code along with the types of advertisment that is newspaper, magazine, cinema, poster and web related proccess or any other format. The database is created successfully along with the necessary communication between staff and client. The client represents the product for the product the company can shows the information of campaign and also advertisement type and then process evolution. The placement details are measured using the placement table. Then the component table is created for maintain the component of the process.The distribution of placement is contains the information of the how the various product can advertise through the Delphi promotion company. All this information included with the database creation and performed some database manipulation process on the input data.
References
Kroenke, D. M.,2016. Database Processing: Fundamentals, Design, and Implementation, 10th ed. Upper Saddle River, NJ: Pearson Prentice Hall.
Mannino, M. V. ,2018. Database Design, Application Development and Administration. Boston: McGraw Hill Irwin.
Pratt, P. J., &Adamski, J. J. ,2015. Concepts of Database Management, 5th ed. Boston: Thompson Course Technology. Rob, P., & Coronel, C. (2007). Database Systems: Design, Implementation, and Management, 7th ed. Boston: Thompson Course Technology.
Jing Han, Meina Song, and Junde Song,2016.”A Novel Solution of Distributed Memory NoSQL Database for Cloud Computing”, In ICIS 2011, 10th IEEE/ACIS International Conference on Computer and Information Science.
Know more about UniqueSubmission’s other writing services:
