Hi all, i have two questions that i did not get what i supposed to write in answ

Question

Hi all, i have two questions that i did not get what i supposed to write in answering them .

first, we are working in building a website , thus in implementation document they asked as to provide a database design by providing the implementation-level details of all the tables, fields and relationships. what does that mean ? what i supposed to write here .

second question is about database connectivity Discuss in detail the mechanism used to integrate the user interface with the backend database.

Details of how you connected the interface to backend tables describe how data at interface layer is converted into data in tables ?

i am using PHPMyAdmin , and i do not what they mean by this question

Explanation / Answer

it does not matter which language you use in software design, as the core concepts invloved in the designing hold for all.

what they want from you is to show how you came up with the database which you have used in your website, you can explain the implementation of your database through the follwoing parameters -

1. provide your entities -

The types of information that are saved in the database are called 'entities'. These entities exist in four kinds: people, things, events, and locations. Everything you could want to put in a database fits into one of these categories. Entities can be Customor, Products, Shops and such.

2. state the relationships -

The next step is to determine the relationships between the entities and to determine the cardinality of each relationship. The relationship is the connection between the entities, just like in the real world: what does one entity do with the other, how do they relate to each other? For example, customers buy products, products are sold to customers, a sale comprises products, a sale happens in a shop.

The cardinality shows how much of one side of the relationship belongs to how much of the other side of the relationship. First, you need to state for each relationship, how much of one side belongs to exactly 1 of the other side. For example: How many customers belong to 1 sale?; How many sales belong to 1 customer?; How many sales take place in 1 shop?

3. State the Attributes -

The data elements that you want to save for each entity are called 'attributes'.

About the products that you sell, you want to know, for example, what the price is, what the name of the manufacturer is, and what the type number is. About the customers you know their customer number, their name, and address. About the shops you know the location code, the name, the address. Of the sales you know when they happened, in which shop, what products were sold, and the sum total of the sale. Of the vendor you know his staff number, name, and address. What will be included precisely is not of importance yet; it is still only about what you want to save.

Presenting Entities and Relationships: Entity Relationship Diagram (ERD)

The Entity Relationship Diagram (ERD) gives a graphical overview of the database. Sketch an ER diagram of your database model to describe its schema.

Additionally, state the primary keys, attribute keys and to what extent your design is normalised.

---------------

The second part is hard to generalise, it is mostly about how the backhend of your project works. Just provide the processes/parsing/convertions which are involved in how you process and store data in your database.

-------------------

Implementation Document is complemently upto you (since you're the designer) and almost anything that you might write is correct since, only will have access to the source code ;)

-----------------

thank you

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.