Encerrado

Design project -- 2

1.

This is an individualized project.

2. Create a database in Microsoft Access 2013.

3. Your project description page should have your name and email address the topic of your database.

4. You must have a topic for your database. A database should serve a purpose and address specific database problem.

5. Create an Entity-Relationship diagram for your database, use the CHEN model.

6. The database should have at least 5 tables; additional tables can enrich your design and improve your database functionality. The each table should have at least 15-25 records (more is acceptable).

7. The content must be relevant to the database fields.

8. The database must be normalized.

9. You should use data and table validation rules and data validation text for each table

10. Each table must have either a single field primary key or a composite one.

11. You must have foreign keys to build relationships between your tables.

12. Your database must have input masks for all the fields that accepted inputs masks (such as Social Security Number, phone number, zip code, password, etc).

13. Your database must have relationships and referential integrity established between the tables.

14. Your database must have at 10 none trivial queries with criteria. Each query should be stated in English in the project description document then answered in Access GUI interface.

15. 4 queries should pull data from at least two tables.

16. Implement Combo Box and Option Group in your forms. At least one implementation of each feature should be part of your forms. Two Combo Box and Two Option Groups

17. A switchport should be created to control access to your database objects such as form and reports. Each form should have a Control button

18. Your database must include 4 working forms. Each form adds data to each of the tables in the database..

19. Your database forms may have pictures related to the database entries [optional].

20. Your database must include 4 reports --- 2 reports based on tables and 2 reports based on queries.

21. Check spelling and grammar in your database.

22. Using Word, type a detailed document explaining what your database is about and its architecture, design on how it works. Include explanation of the data in the tables, queries, forms, reports. Why you chose this specific topic, what type of problems or challenges have you encountered? How much did you learn from this project in relation to the class concept and how much did you learn MS Access as a database application. What do you think of access as a tool for teaching this class

23. Deliverables: In one zipped file includes the following files: (1) Your database file, (2) Your database description document including database design in ERD

Habilidades: Gestão de marcas, Identidade Corporativa, Design Gráfico, Design de logotipo, Design de Sites

Ver mais: design gui activex control, design circuit home control, design model reference control, design mode custom control, design website pest control, design develop admin control

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #11749553

9 freelancers estão ofertando em média $26 para este trabalho

transformindesi9

With decades of experience I am able to apply not only theoretical knowledge, but also technical ability and creative influence to all areas of my work. Portfolio on the following link https://www.freelancer.com/u Mais

$30 USD em 1 dia
(158 Comentários)
6.6
ChetnaArts

Please Give ME a chance as I am very Serious at my work. Hi, I have read Your project description. I will Provide you with Great Options in less than 24 Hours. You can check my profile & Portfolio here and Mais

$12 USD em 1 dia
(80 Comentários)
5.6
IdeasNcreations

Services of a professional and experienced designer are available who is expert in delivering quality and creative designs for you. Send me a text to start the discussion on your project.

$25 USD em 1 dia
(59 Comentários)
5.1
zibesco

Dear Client, ZIBESCO Is A Professional Graphic Designer Team Of Experienced And Hard Working. Our Service Is Day And Night To Deliver High Quality Work In The Best Possible Price And Within Minimum Time F Mais

$25 USD em 1 dia
(51 Comentários)
4.5
programmernabeel

Dear Sir, Hope you are doing well today, I have read your project description, i am willing to do this task for you. i have done similar work before and got a good review. please come on chat, so we can disc Mais

$25 USD em 1 dia
(4 Comentários)
3.8
CreativeSubha

Hello, Please check my designs at 1st and if you like my work then please don't hesitate to contact me. Thanks, Subha

$35 USD em 1 dia
(1 Comentário)
2.3
Softeria

I am a Database Developer. I have 5 years of experience working with SQL/MYSQL and Oracle. I am currently working on SQL server 2008 and Oracle10g. I can Develop you ER Diagrams (Crows foot notation), EERD, I can conve Mais

$30 USD em 1 dia
(1 Comentário)
2.2
$25 USD em 1 dia
(0 Comentários)
0.0
don6bosco

Hi I am a software engineer with 7 yrs of exp in various technologies. The reason for taking up this project, is just interest in the ERD. and the work is feasible. Please contact me if you believe I can.

$25 USD em 1 dia
(0 Comentários)
0.0