Question

Hey can you please answer this question in detail and explanation in your own word i need to post in discussion board

1. Are there ethical issues to consider when designing a database? For example, should highly sensitive personal data (such as patient medical information) be stored in the same database that manages and contains office supply inventories? Why or why not?
2. Suggest three situations where referential integrity and relationships, inherent in a relational database management system (RDBMS), avoids data problems.
3. Do a bit of research on the Internet regarding the differences between SQL-based vs. NoSQL type databases. If you were designing a college course registration system for MC3 which database type would you recommend for the system's "back-end" and why?

Be sure to give thought to each assigned question before posting.

Answer 1

Privacy is a high-profile public policy issue that affects everyone.Privacy of data becomes more sensitive in cloud database as it allows to store,manage and sharing of complex data in the secured platform. Cloud databases has challenges like lack of awareness about the place of data stored, datas transaction logs,among others. Also, ethical issue includes issues regarding trust from tenants, as the they find it very difficult in outsourcing critical information to a cloud service provider without the interference of a third party. Some of the other issues that have strong ethical concerns in database are  increase in size of data, increased sophistication in mechanisms and convenience to access systems, increased invisibility increase in circulations, globalized sharing of informations, increased interaction with other databases and applications, increased amounts of personal information, and poor security for the databases.

Storing highly personal sensitive data in the same database that manages and contains office supply inventories makes the above situations even more worser.The vulnerability of data becomes its peak which even can cause individual issues.The personal data even contain their mental and emotional well-being. The exposure of these data causes many other problems like others taking time on this , mental issues faced by the patient due to exposure of their health conditions and so on.
   So it is considerably better to keep those highly personal data seperately to avoid above metioned type of exposures.

The Referal integrity refers to the accuracy and consistency of data within a relationship.The relational model supports the well-defined theory of constraints on attributes or tables.The domain restricts the values of attributes in a relation and it is a constraint of the relational model. However, there are real-world semantics for data that cannot be specified if used only with domain constraints. Thus there is a need of specific ways to state what data values are or are not allowed and which format is suitable or not suitable for an attribute.In relationships, the data is linked between two or more tables. This is achieved by having the foreign key reference to a primary key value.

For a college course registration system for MC3 its recommended to use SQL based database.
SQL databases defines and manipulates data based on the structured query language which is extremely powerful. It is one of the most versatile and widely-used as a safe choice especially for great complex queries. But from other side it can be restrictive. SQL requires you to predefined schemas to determine the structure of data. Also all data should be in the same structure.Thus a change in the structure would be very difficult to the  whole system.The SQL databases are vertically scalable which  means that we  can increase the load on a single server by increasing things like RAM, CPU or SSD.These databases are best suited for complex queries.

A NoSQL database has dynamic schema for unstructured data. The data is stored in many ways like it can be document-oriented, column-oriented, graph-based or organized as a KeyValue store. This flexibility helps to create documents without having defined structure first. Also it helps the documents to maintain its own unique structure. The syntax varies from database to database, which helps to add field as needed.These databases are best suited for hierarchical data storage and are not suitable for complex queries. These databases are horizontally scalable.

As the course registration system for MC3 has a complex database it is better to have an SQL based database.It would be the perfect choice.