Zamknięty

a part of database project

in the attachments you can see part 1&2 which I have done..

Now I only need someone to make Part 3&4

PART#3

1. Start implementing your database by performing the following steps:

a. Generate the relational database schema of your chosen database. Make sure it is correct, if it needs any modifications, do them at this stage.

b. Use MySQL and DDL to define your schema to MySQL’s RDBMS.

c. Use MySQL and DML to populate your database with sample data.

d. Make a list of all your system’s business rules that could not be expressed as integrity rules in the relational schema. These rules are to be programmed in your implementation.

2. Design the user interface for input forms, output and report request screens for your database.

a. Screens must be designed to be useful, clear and easy to use. A single screen may show data from many tables or may look like a parent record with many child (dependent) records … etc.

b. Screens may be used to enter new data, retrieve data for display, edit existing data, and/or request queries and reports. They must be designed consistently.

c. Reports of your system must include at least one of each of the following kinds of reports:

i. Reports that print evidence of some transaction, like an invoice, receipt, ticket….

ii. Reports that print data for some entity along with its dependencies, like a certain customer along with all his purchases … etc.

iii. Reports of list nature, like the list of available rooms in a hotel, and the like.

iv. Reports that give summaries from the database, like sums, averages and the like.

PART #4

1. Implement your database design by performing the following steps:

a. Write SQL/PHP program modules to implement all the business rules that could not be expressed as integrity rules in the relational schema. Each module shall be called upon for execution when the situation requires checking for a particular business rule. You may write these modules in JavaScript if you like.

b. Implement the user interface screens and reports you designed in part3 of the project as a set of Web-based PHP programs.

i. Try to use modular functions as much as possible, to avoid clumsy, cluttered and un-readable programs.

ii. Make a clear separation between sections of code that are HTML, PHP and SQL.

2. Test your system of PHP programs and modules, one-by-one making sure they work as required, with no conflicts, and that all rules are enforced. Screens and reports must be consistent with database and your earlier designs.

Umiejętności: Programowanie w C#, Administrowanie bazami danych, Programowanie w bazie danych, MySQL, SQL

Zobacz więcej: database project purchases table, autocad project designs, movie database project, database project via web, php database project, access database project, database project examples netbeans, database project football, database project vbnet, fisheries database project, netbeans database project, access database project java, database project visual studio visual basic, college database project, visual basic database project stored excel, database project sports team

O pracodawcy:
( 2 ocen ) Jeddah, Saudi Arabia

Numer ID Projektu: #16762639

4 freelancerów złożyło ofertę na kwotę $67 do tego projektu

Creativeartbd

Well, So you want a PHP and MySQL application where you want to add data, get data and update data using the HTML for, Is that right? If so ping me via chat. Thanks.

$100 USD w ciągu 2 dni
(39 Oceny)
6.0
bidroid

Hello How are you? I had worked for +7 years in IT company as a CV/ML developer. I have deep experience with developing many projects in c, c++, matlab and python. I like smart work. If you want, please feel fr Więcej

$25 USD w ciągu 1 dnia
(1 Ocena)
1.5
numanmansha

hi, i am available right now for this work, kindly send me further details about it. thank you regards nouman software engineer

$111 USD w ciągu 7 dni
(0 Oceny)
0.0
niketchauhan

I have worked on various relational databases like Oracle, DB2 and MySQL. I have also created a web application using the codeigniter framework for a courier service firm. Hence I have a lot of experience in forming an Więcej

$30 USD w ciągu 5 dni
(0 Oceny)
0.0