Project :

The database project of the advertisement center system Advertising centers are small advertising centers that operate under the supervision of a larger organization such as larger advertising companies. An advertising center is the developer of the program and all aspects related to customer advertising. Advertising centers can operate in a specific area or completely take over all advertising services of a client. The advertising center creates the leaven of the client's advertisements, such as the website, cyberspace campaigns, print advertisements, logos and visual identity, etc., all of which are formed in the form of a single plan and looking at the client's advertising goal. It is organized. . .

It should have 30 tables and the project includes 4 phases :

Task 1: System design: system architecture, functions, ER diagrams, database advertisement center system, interface, etc.

The first phase of drawing an ER diagram, which includes entities, ratios such as (1, n), (1, n) (n, n) and attributes and relationships

The second phase of the mapping of all kinds of phenomena

Task 2: Implementation: MySQL

And finally, the last phase of normalization

This includes the following:

1- Defining the system functions and analyze the data Flowcharts and data diagrams

Design the functionality

2- Designing the Database creating the tables

designing the relationships between the tables

defining the constraints Normalization Defining the Roles and users of the system (Giving Authorities).

3- Designing the website

Client side coding

Add the SQL Functionality: The SQL Queries.

Server side coding

The path architecture of the server.

Subscribe to web hosting service to host both database and apache server to deploy the project.